RE: sqlplus and spaces in path
- From: "Karla, Srini \(HAS-SAT\)" <Srini_Karla@xxxxxxxxxxxx>
- To: <sbootsma@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 12:59:36 -0500
Enclose all the .sql calls with double quotes, it works.
Example:Test3.sql
spool test3.log
@@"c:\sqls test\ab_users.sql"
@@"c:\sqls test\ac_users.sql"
spool off
Thanks,
Srini Karla
Sr. Database Administrator,
Harcourt Assessments, Inc.,
San Antonio, TX 78259
210-339-5252 work
210-683-3936 cell
---------------------------------------------------
Our Sharepoint: http://hassatappp022/sites/epa/ea/default.aspx
---------------------------------------------------
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Cary Millsap
Sent: Wednesday, August 22, 2007 11:04 AM
To: sbootsma@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: sqlplus and spaces in path
Use the DOS "8.3" filename format. You can see what I mean with a
"dir/x" command from DOS. Instead of "C:\Documents and
Settings\whatever", you'd use "c:\docume~1\whatever".
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Nullius in verba
Hotsos Symposium 2008 / March 2-6 / Dallas
Visit www.hotsos.com for curriculum and schedule details...
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sam Bootsma
Sent: Wednesday, August 22, 2007 9:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: sqlplus and spaces in path
Hello All,
I am on Oracle database 10.2.0.3. My sqlplus version is 10.1.0.5.0.
I have a sql script in a directory with embedded spaces (for example,
directory C:\Documents and Settings\Staff\My Documents\_a). This sql
script includes a couple of calls to other sql scripts using @@. For
example:
....
@@sqlfile2
....
I can call my main sql script by enclosing the path and file name in
single or double quotes. But when this sql script calls another script
using @@ (eg. @@sqlfile2), sql plus returns an error like:
"SP2-0310: unable to open file "C:\Documents.sql"
Is there any solution to this problem? Is it possible to load into
sqlplus a script from a directory which has spaces in its name, and this
file to call other files from the same directory with @@)?
Thanks for any suggestions!
Sam Bootsma
Oracle Database Administrator
Information Technology Services
George Brown College
Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma@xxxxxxxxxxxxxx <mailto:sbootsma@xxxxxxxxxxxxxx>
Other related posts:
