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

devmcg03 (AT) gmail (DOT) com wrote:
Oracle has never supported long filenames, even not when installing the
software. Assuming you install Oracle in c:\oracle\product etc...
the preferred location for scripts is c:\oracle\admin\scripts.
Learn to live with it, and stop searching for a non-existing solution.

--
Sybrand Bakker
Senior Oracle DBA

Apart from Sybrand's correct suggestion, you could CD to the correct
directory from a command-prompt and run the relevant script from the
DOS SQL*Plus client.

HTH

-g

"sybrandb" <sybrandb (AT) gmail (DOT) com> wrote

I've never had problems using doublequotes. Using 9207:

SQL> connect /@prod
Connected.
SQL> @"c:\program files\oracle\x.sql"

SYSDATE
---------
18-JUL-06

SQL>

--
Terry Dykstra

devmcg03 (AT) gmail (DOT) com wrote:
Another option is to use the DOS 8.3 convention:

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


HTH,
Brian


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

Brian Peasland
dba (AT) nospam (DOT) 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