SPOOL IS NOT WORKING IN 11g

3,604 views
Skip to first unread message

RAJESH

unread,
Jul 11, 2012, 3:59:31 AM7/11/12
to Oracle PL/SQL
hi


SQL> spool test.doc
SP2-0606: Cannot create SPOOL file "test.doc"

i m getting this error while writing spool command.
i m using 11g
wat to do


thanks

Michael Moore

unread,
Jul 11, 2012, 10:48:07 AM7/11/12
to oracle...@googlegroups.com
use the full path name : spool c:\myfolder\test.doc


--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle...@googlegroups.com
To unsubscribe from this group, send email to
Oracle-PLSQL...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

ddf

unread,
Jul 12, 2012, 11:31:53 AM7/12/12
to Oracle PL/SQL
You have no write permissions for the directory you started SQL*Plus
from. This is NOT a spool issue, it's an O/S permissions issue. Find
a directory where you DO have write privileges and spool the file
there by using the full path name, as Michael mentioned.


David Fitzjarrell
Reply all
Reply to author
Forward
0 new messages