Home » SQL & PL/SQL » Client Tools » sqlplus: path with spaces (sqlplus)
sqlplus: path with spaces [message #342092] Thu, 21 August 2008 05:40 Go to next message
Messages: 35
Registered: July 2006

I have the following script (launch_install.sql) that I am trying to execute:

exec script.prepare_install;
@c:\my project\install.sql;

I am using sqlplus under windows. The problem is that i get an error message "unable to open file 'my.sql'". sqlplus thinks the command line finishes with the first blank. I've tried single and double quotes to no avail.

Is there a solution?

Re: sqlplus: path with spaces [message #342115 is a reply to message #342092] Thu, 21 August 2008 06:53 Go to previous message
Michel Cadot
Messages: 67287
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It works with double-quotes:
SQL> @"C:\Program Files\t.sql"
21/08/2008 13:52:17

1 row selected.

But SQL*Plus doesn't like space in file names, you should avoid it and change your directory name.

Previous Topic: Is SPAM admin tool a Oracle product?
Next Topic: Isidian Technologies - Does the company still exist?
Goto Forum:

Current Time: Wed Aug 05 20:55:50 CDT 2020