Home » RDBMS Server » Server Utilities » SQL*Plus Paths on Windows
SQL*Plus Paths on Windows [message #200611] Tue, 31 October 2006 08:45 Go to next message
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

Re: SQL*Plus Paths on Windows [message #200615 is a reply to message #200611] Tue, 31 October 2006 09:04 Go to previous message
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'



Hope this helps.
Previous Topic: Sqlldr issue with Oracle 8i
Next Topic: Import to remote server
Goto Forum:

Current Time: Tue Oct 25 12:49:06 CDT 2016

Total time taken to generate the page: 0.11385 seconds