Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sqlplus not allowing spaces
"sybrandb" <sybrandb_at_gmail.com> wrote in message
news:1153236005.899758.269460_at_m73g2000cwd.googlegroups.com...
>
> 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
>
> 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
>
I've never had problems using doublequotes. Using 9207:
SQL> connect /@prod
Connected.
SQL> @"c:\program files\oracle\x.sql"
SYSDATE
-- Terry DykstraReceived on Tue Jul 18 2006 - 11:09:25 CDT