SP2-0768: Illegal SPOOL command
Usage: SPOOL { | OFF | OUT }
where is file_name[.ext] [CRE[ATE]|REP[LACE]|APP[END]]
This error came when you are trying to create log file from SQL* loader using SPOOL command.
reason:
This error came because of two reason
1. Wrong path for spool file
2. @*.sql file contain invalid characters
Solve:
1. In my case i am trying to set spool file at path
spool C:\Users\******\Desktop\New folder\extract.log
It throws error because of "New folder" Folder name contain space
so Correct syntax to write the command either remove the space from folder name or enclosed the path in single quotes
2. If you are tring to execute the @*.sql file which contain the spool command can cause error because some times in linux file contains
invalid characters like ^M
In that case you need to remove the invalid chars from file.
Usage: SPOOL {
where
This error came when you are trying to create log file from SQL* loader using SPOOL command.
reason:
This error came because of two reason
1. Wrong path for spool file
2. @*.sql file contain invalid characters
Solve:
1. In my case i am trying to set spool file at path
spool C:\Users\******\Desktop\New folder\extract.log
It throws error because of "New folder" Folder name contain space
so Correct syntax to write the command either remove the space from folder name or enclosed the path in single quotes
2. If you are tring to execute the @*.sql file which contain the spool command can cause error because some times in linux file contains
invalid characters like ^M
In that case you need to remove the invalid chars from file.
Thank you! ... it worked
ReplyDeleteIt worked for the first time... however if i tried to give a different path next time it dose not work.
ReplyDeleteThank You
ReplyDeleteThank you, it worked.
ReplyDeleteThank you for your comment regarding enclosing the file path in single quotes...newbie mistake on my part!
ReplyDeleteI received this error without having any spaces in my file path. Drove me nuts until I found that I had an extra space in the "spool off" command. Just didn't see that extra space, which made the spool command throw this error.
ReplyDeleteLinex spool
ReplyDelete