OraFAQ Forum: Server Utilities » SQL*Plus Paths on Windows

Home » RDBMS Server » Server Utilities » SQL*Plus Paths on Windows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*Plus Paths on Windows [message #200611]

Tue, 31 October 2006 08:45

daraii
Messages: 10
Registered: September 2006

Junior Member

What should I do to load a script in SQL*Plus running on Windows command line when the script is not located on the same directory as the SQL*Plus and the dir name contains spaces? For example:

@C:\Documents and Settings\Adm\Desktop\test.sql

Thanks.

Report message to a moderator

Re: SQL*Plus Paths on Windows [message #200615 is a reply to message #200611]

Tue, 31 October 2006 09:04

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

SQL> edit test.sql

SQL> host dir test.sql
 Volume in drive C has no label.
 Volume Serial Number is CC55-E5A1

 Directory of C:\Documents and Settings\m.taj

31-10-2006  07:02 PM                26 test.sql
               1 File(s)             26 bytes
               0 Dir(s)   8,221,786,112 bytes free

SQL> @'c:\documents and settings\m.taj\test.sql'

'ORACL
------
oracle

SQL>

Hope this helps.

Report message to a moderator

Previous Topic:	Sqlldr issue with Oracle 8i
Next Topic:	Import to remote server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 16:37:53 CDT 2024