Re: Pathname for Spool - [NT]

Sean:

Use the shorter 8.3 directory name. You can get it with the dir /x command. Then you could do something like:

t:\oracle\output\system~1\free_space.log

Jon Walthour
>
> From: "O'Neill, Sean" <Sean.ONeill_at_organon.ie>
> Date: 2001/08/14 Tue AM 10:15:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Pathname for Spool - [NT]
>
> Can anyone tell me if it is possible to specify a pathname using NT to a
> file with SQL*Plus spool command if the pathname contains a space. For
> example if I want to spool output of a SQL*Plus session to
> t:\oracle\output\system check\free_space.log can this be done. I've tried
> enclosing the pathname in " " and ' ' but that don't do it, it gives same
> error message as for no "" or '':
>
> SP2-0333: Illegal spool file name: "t:\oracle\scripts\system
> checks\free_space.log" (bad character: ' ')
>
> I'm hoping that I won't be stuck with having directory names with no spaces,
> arrrggghhhhhh.....
> (and puhhleezze no comments about on Unix yada, yada, yada)
>
>
> Sean :)
>
> Rookie Data Base Administrator
> Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
> [0%] OCP Oracle8i DBA
> [0%] OCP Oracle9i DBA
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA
>
> "Nobody loves me but my mother... and she could be jivin' too." - BB King
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).