Re: sqlplus not allowing spaces

devmcg03_at_gmail.com wrote:
> I'm on win2003 with Oracle 10.1 server
>
> It seems the SQL+ has a problem with spaces. I am trying to run a
> script that contains the Program Files directory in it's path. I am
> getting errors and I was hoping someone here might have a suggestion to
> get this to run. I've tried enclosing the path in single and double
> quotes but that's not working. Any suggestions?
>
>
> *not working*
> @C:\Program Files\scripts\test.sql
> @'C:\Program Files\scripts\test.sql'
> @"C:\Program Files\scripts\test.sql"
>
>
> SP2-0310: unable to open file "C:\Program.sql"
>
>
> dave
>

Another option is to use the DOS 8.3 convention:

@C:\Progra~1\scripts\test.sql

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown