As to dynamically deciding if you are on windows or unix -- one method
is to query v$controlfile and parse out the slash. Forward slash
indicates unix, back slash indicates windows.

select * from v$controlfile;
STATUS NAME
------- ----------------------------------------------
/u02/oradata/GISPROD/control01.ctl
/u03/oradata/GISPROD/control02.ctl
/u04/oradata/GISPROD/control03.ctl

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
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>



---------------------------------------------------------------------
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