| "Not spooling currently" Error message [message #390116] |
Thu, 05 March 2009 01:02  |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Hi All,
I am getting the following message while executing ".sql" file.
not spooling currently
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Can any one please let me know the reason for getting this message and give me the solution for this.
Thank you
|
|
|
|
|
|
| Re: "Not spooling currently" Error message [message #390120 is a reply to message #390116] |
Thu, 05 March 2009 01:11  |
flyboy
Messages: 1903
Registered: November 2006
|
Senior Member |
|
|
| user71408 wrote on Thu, 05 March 2009 08:02 | Can any one please let me know the reason for getting this message and give me the solution for this.
|
I think the error message is self-descriptive.
SQL> spool a.txt
SQL> spool off
SQL> spool off
not spooling currently
SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL>
You see the command which issued that message. Find it in the script (if there are more, take the one without matching SPOOL <filename>) and remove it.
|
|
|
|
| Re: "Not spooling currently" Error message [message #390122 is a reply to message #390117] |
Thu, 05 March 2009 01:23 |
user71408
Messages: 585
Registered: November 2007
Location: NE
|
Senior Member |
|
|
Michel,
Now I gave
SPOOL ON
SQL Query
Spool Off
now I am getting
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
one more thing is I want to spool this data to abcd_<Sysdate>.txt. Please tell me how to do that.
Thank you,
[Updated on: Thu, 05 March 2009 01:25] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
