Works on the 10g client.



11:33:10 GENTRAN @ gisprod> spool "c:\program files\ATI
Technologies\testing.lis"

13:25:33 GENTRAN @ gisprod> select * from dual;



D

-

X



1 row selected.



Elapsed: 00:00:00.04

13:25:37 GENTRAN @ gisprod> spool off





Joel Patterson

Database Administrator

joel.[Email address protected]

x72546

904 727-2546



-----Original Message-----
From: Bill Zakrzewski
[mailto:oracledba-ezmlmshield-x31125054.[Email address protected]
Sent: Tuesday, September 04, 2007 1:00 PM
To: LazyDBA Discussion
Subject: Re: Spooling to a filename that contains spaces



Not sure if anyone responded, but this might help.....



http://www.cedet.dk/oracle/180795.1.html



Good luck-

Bill



Williamson Nick wrote:

> Hi all,

>

> Oracle 9i doesn't like this:

>

> spool 'c:\temp\spaces in the name\nick.txt'

>

> ...and it doesn't seem that I can fix the problem by wrapping the

> filename in an extra pair of single quotes. I know that on Windows, I

> can change it to:

>

> spool 'c:\temp\spaces~1\nick.txt'

>

> ...but I'd like a solution that would work on Unix as well. Is there a

> way to do it?

>

> TIA

> Nick






Oracle LazyDBA home page