|
|
Re: SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674218 is a reply to message #674212] |
Fri, 11 January 2019 00:37 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
SP2-00606: Cannot create %s file \"%s\"\n
*Cause: The STORE or SPOOL command was unable to create the specified
file. There may be insufficient disk space, too many open
files, or read-only protection on the output directory.
*Action:Check that there is sufficient disk space and that the
protection on the directory allows file creation.
[Updated on: Fri, 11 January 2019 00:38] Report message to a moderator
|
|
|
Re: SP2-0606: Cannot create SPOOL file "password/hr_main.log" [message #674220 is a reply to message #674212] |
Fri, 11 January 2019 04:15 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
What file are you running? The hr_main.sql file in the db-sample-schemas-18c.zip that you should have downloaded from Github gives you two more prompts before enabling spooling. From the top of the file:PROMPT
PROMPT specify password for HR as parameter 1:
DEFINE pass = &1
PROMPT
PROMPT specify default tablespeace for HR as parameter 2:
DEFINE tbs = &2
PROMPT
PROMPT specify temporary tablespace for HR as parameter 3:
DEFINE ttbs = &3
PROMPT
PROMPT specify password for SYS as parameter 4:
DEFINE pass_sys = &4
PROMPT
PROMPT specify log path as parameter 5:
DEFINE log_path = &5
PROMPT
PROMPT specify connect string as parameter 6:
DEFINE connect_string = &6
PROMPT
-- The first dot in the spool command below is
-- the SQL*Plus concatenation character
DEFINE spool_file = &log_path.hr_main.log
SPOOL &spool_file
|
|
|