spool to location

[kpate]

How to spool to location which has a space in folder name:
column dcol new_value mydate noprint

select 'w:\Risk Control\public\Reports\'||to_char(sysdate,'YYYY\MM\MMDDYYYY') dcol from dual;

spool &mydate\rest.txt;

select sysdate from dual;

spool off;

It works fine when i take space out like :
Risk Control to RiskControl

[gandolf989]

You can use the short name. do a dir/x in dos from the w: drive and it will give you the 8.3 version of the directory.

[kpate]

????????? no clue

[Mr.Hanky]

Rename the folder with an underscore.

[gandolf989]

Originally posted by kpate
????????? no clue

Have you ever clicked on start, then run and typed in cmd and enter? That would bring you to the dos prompt. Enter "W:" and enter to go to the W: drive and then type "dir /x" and then enter to see all of the files in that directory using a short name.

Back when Windows 3.11 was out and it was a 16 bit operating system being able to create a file name larger than 8 characters was a new thing. So in addition to the long name every file had an abbreviation consisting of the first 6 letters a "~" or tilde and a number signifying the name of the file.

There fore the short name for "Risk Control" would probably be "riskco~1". If it were a text file it would be something like "riskco~1.txt". Hence 8.3, an 8 character name with a 3 character extension.

Or you could just change the space to an underscore.

[marist89]

If you ever worked with a real operating system instead of a "pretty" face on top of DOS you would know to:

SQL> spool "c:\Documents and Settings\jhunter\foobar.out"

[gandolf989]

Originally posted by marist89
If you ever worked with a real operating system instead of a pretty face on top of DOS you would know to:

SQL> spool "c:\Documents and Settings\jhunter\foobar.out"

Hmmmm. I just assumed that it would work.
Maybe there is a setting missing in my Oracle client.

SQL> spool "c:\Documents and Settings\jhunter\foobar.out"
SP2-0333: Illegal spool file name: ""c:\Documents and Settings\jhunter\foobar.out"" (bad character:

That is the first time I ever heard you call Windows a pretty face!

[marist89]

There, edited for sarcasm effect...

[gandolf989]

Originally posted by marist89
There, edited for sarcasm effect...

That's much better.

Thanks.