Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlplus and spaces in path

RE: sqlplus and spaces in path

From: Karla, Srini \(HAS-SAT\) <Srini_Karla_at_harcourt.com>
Date: Wed, 22 Aug 2007 12:59:36 -0500
Message-ID: <A2B00E685298CF4E8D1E5288432D025E03F7BDF9@HASSATEXCP07VA.edu.regn.net>

 

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap
Sent: Wednesday, August 22, 2007 11:04 AM To: sbootsma_at_georgebrown.ca; oracle-l_at_freelists.org 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sam Bootsma
Sent: Wednesday, August 22, 2007 9:34 AM To: oracle-l_at_freelists.org
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_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>  

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 22 2007 - 12:59:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US