Spooling to a filename that contains spaces

Spooling to a filename that contains spaces

 

  

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