Re: Spooling to a filename that contains spaces

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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>


Oracle LazyDBA home page