| Author |
Message |
Brian Peasland
*nix forums Guru
Joined: 04 Apr 2006
Posts: 301
|
 Posted: Tue Jul 18, 2006 4:20 pm Post subject:
Re: sqlplus not allowing spaces
|
|
|
devmcg03@gmail.com wrote:
| Quote: | 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@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 |
|
| Back to top |
|
 |
Terry Dykstra
*nix forums addict
Joined: 19 Apr 2005
Posts: 63
|
| Posted: Tue Jul 18, 2006 4:09 pm Post subject:
Re: sqlplus not allowing spaces
|
|
|
"sybrandb" <sybrandb@gmail.com> wrote in message
news:1153236005.899758.269460@m73g2000cwd.googlegroups.com...
| Quote: |
devmcg03@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
---------
18-JUL-06
SQL>
--
Terry Dykstra |
|
| Back to top |
|
|
gazzag
*nix forums Guru Wannabe
Joined: 08 Jun 2005
Posts: 277
|
| Posted: Tue Jul 18, 2006 3:37 pm Post subject:
Re: sqlplus not allowing spaces
|
|
|
| Quote: | devmcg03@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
|
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 |
|
| Back to top |
|
|
sybrandb
*nix forums beginner
Joined: 13 Jul 2006
Posts: 22
|
| Posted: Tue Jul 18, 2006 3:20 pm Post subject:
Re: sqlplus not allowing spaces
|
|
|
devmcg03@gmail.com wrote:
| Quote: | 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 |
|
| Back to top |
|
|
devmcg03@gmail.com
*nix forums beginner
Joined: 18 Jul 2006
Posts: 5
|
| Posted: Tue Jul 18, 2006 3:10 pm Post subject:
sqlplus not allowing spaces
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
