Getting error while using SPOOL with APPEND

Question

I am using SQLPLUS version DEFINE _SQLPLUS_RELEASE = "1102000200" (CHAR). In which i am trying to spool a file which is already exist with append command. But it's giving me an error as

SQL> spool test_dir/test.txt append; SP2-0556: Invalid file name.

can any one please help me why am i getting this error

score 0 · Answer 1 · answered Dec 05 '19 at 11:22

0

Spool is a client side utility and generates the file at same location or from where you are executing the script or location from where your sqlplus is started or at path specified by you. not in oracle server directory.

Now, in your you case specify the whole path then it will work.

Something like:

Spool c:\windows\temp\test.txt

Cheers!!

answered Dec 05 '19 at 11:22

Popeye

35,427
4
10
31

The mentioned directory is full path for the file. Not sure why i am getting the error even after mentioning the full path. Also the same path works fine with out APPEND :-(e – teepu Dec 05 '19 at 12:08
**The mentioned directory is full path for the file.** means?? is `test_dir` a directory? – Popeye Dec 05 '19 at 13:26
Yes, it is the directory. – teepu Dec 06 '19 at 05:50
I mean oracle directory? – Popeye Dec 06 '19 at 06:16
Yes, oracle directory – teepu Dec 06 '19 at 07:35

Getting error while using SPOOL with APPEND

1 Answers1