Iam using windows 7 32 bit and Oracle 11g
SQL> spool off
SQL> host type c:\spool.txt
The system cannot find the file specified.
help me to solve the above ploblem
ganges
0
Newbie Poster
rubberman
1,355
Nearly a Posting Virtuoso
Featured Poster
Oracle was developed for Unix systems which use a backslash as an escape character. Try either a forward slash, or a double back-slash. I haven't run Oracle on Windows systems so I am surmising here. IE: try either c:/spool.txt or c:\spool.txt and see what happens. Also, if you look at the root of the c drive, do you see the file?
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.