Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus: Help with Spooling (path and file questions)

Re: sqlplus: Help with Spooling (path and file questions)

From: Greg <esabens_at_yahoo.com>
Date: 9 Oct 2006 10:43:29 -0700
Message-ID: <1160415809.429971.125280@m7g2000cwm.googlegroups.com>

sybrandb wrote:
>
> Are you getting this message (please always be as specific as possible
> and try to avoid forcing people in reproducing your problem)
> SP2-0333: Illegal spool file name: "m:\home\Big Share\Uploads\2006
> Fall\061009.txt" (bad character: ' ')
>
> Oracle has never allowed NTFS file names, so you either must use DOS
> file names (without spaces and the like) or you must use the hidden DOS
> names.
> Question: Did you look up the error message? To me the problem is
> immediately clear, and I have no doubt the 'feature' is documented.
> You would best try to avoid to ask questions with obvious answers.
>
> To spool a file without extension, just add a trailing dot.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Sybrand,

Thanks for the reply. Your answers were helpful although the lesson on how to write questions seemed a bit arrogant.

Greg Received on Mon Oct 09 2006 - 12:43:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US