Spool to a file with a SPACE 1

[wolves]

Would like to spool to a file directory, that has a space in the directory name. Without changing the directory name, is there any way around this?

SQL> spool C:\Stuff Finance\Financial Data

SP2-0333: Illegal spool file name: "T:\shr_data\Financial Data folder\VCIS Info" (bad character: ' ')

 

[LKBrwnDBA]

1) Create the spool data file first if it has a space in the name.
2) Use the short names:

SQL> spool C:\StuffF~1\Financ~1\VCISIn~1

HINT: Use the dir /x command to find the short names.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[wolves]

Thanks LKBrwnDBA, that was very helpful and that worked.

Thanks for the tip.

 

[SantaMufasa]

Los Lobos,

I'll bet with such a helpful/easy solution to your problem, you wanted to click on "Thank LKBrwnDBA for this valuable post", right?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

@ 16:49 (08Feb05) UTC (aka "GMT" and "Zulu"),
@ 09:49 (08Feb05) Mountain Time

Click here to Donate to Tsunami Relief. 100% of your contributions here go to the victims...0% to administration.
They were "The First-Responder" to the disaster, with relief deliveries arriving before Red Cross and U.S. aid.

 

[wolves]

Thanks for the reminder Mufasa, that's exactly what I just did.