Is there some other way? 2

[desert19]

Is there some other way to access scripts while in sql*plus other than copying them directly to the bin directory in the oracle home directory? If I dont do that tedious task I get this message:

SP2-0310: unable to open file "test.sql"

 

[JHoarty]

Yes. Point to "file/open" and browse to the directory of your script. Then, copy the script using "Ctrl-C", and close the browse window. Paste the script after the "@" sign in your SQL Plus command line and hit "Enter". Let me know if you still get the error. You may have to turn your spool file on.

John Hoarty
jhoarty@quickestore.com

http://www.quickestore.com

 

[carp]

Or specify the full path to the file:

SQL> @c:\scripts\myscript.sql

 

[jquaid]

Or create an icon on your desktop with the path pointing to SQLPLUS and the 'open in' folder pointing to whichever one you want to pick up your files from.

 

[karluk]

If you are using Windows, the search path is determined by the registry variable, SQLPATH. In Regedit, search for this variable. It should be in hkey_local_machine\software\oracle or one of its subdirectories. Edit SQLPATH by adding whatever directories you want searched, separated by semicolons. Then you can run your scripts by just typing the file name.