SQL*Plus not SPOOLing [message #592581] |
Fri, 09 August 2013 13:44  |
 |
abnk
Messages: 30 Registered: January 2012 Location: US
|
Member |
|
|
This is a new install.
This is what I have:
SQL> SPOOL c:\test.txt
SQL> SELECT 1 FROM dual;
1
----------
1
SQL> SPOOL OFF
SQL>
When I check C:\, there's nothing. I searched the entire drive.
Any ideas?
Thanks.
|
|
|
|
|
|
|
|
Re: SQL*Plus not SPOOLing [message #592606 is a reply to message #592599] |
Fri, 09 August 2013 17:00   |
 |
abnk
Messages: 30 Registered: January 2012 Location: US
|
Member |
|
|
Littlefoot wrote on Fri, 09 August 2013 14:04You might not have rights to write to root directory of your C disk (i.e. C:\). Try to spool to C:\users\your_own_directory instead.
I will try that. Thank you.
Edited to add: Actually, I have created folders and files in C:\, but I will try that anyway.
Lalit Kumar B wrote on Fri, 09 August 2013 15:02
Well, I am not sure if it is true in your case, but, with Win7, you need to explicitly select "Run as administrator" for all the tools and applications.
I needed an administrator to install Oracle for me, so this might be it. Thank you.
[Updated on: Fri, 09 August 2013 17:04] Report message to a moderator
|
|
|
|