Sorry so late in responding (been busy). The following was run from SQL*Plus (sqlplus.exe, not sqlplusw.exe) on an Oracle10.2.0.3 DB hosted on Windows XP Pro

SQL> spool "I like spaces.txt"
SQL> select * from global_name;
GLOBAL_NAME
----------------------------------
DBA1
1 row selected.
Elapsed: 00:00:00.00
SQL> spool off
SQL> host type "I like spaces.txt"
SQL> select * from global_name;
GLOBAL_NAME
----------------------------------
DBA1
1 row selected.
Elapsed: 00:00:00.00
SQL> spool off

Todd Pepling
[Email address protected]
724-766-3492

________________________________

From: Bill Zakrzewski [mailto:oracledba-ezmlmshield-x31125054.[Email address protected]
Sent: Tue 9/4/2007 13:00
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
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com <http://jobs.lazydba.com/>
> To Subscribe : http://www.LazyDBA.com <http://www.lazydba.com/>
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>



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





Oracle LazyDBA home page