Home » SQL & PL/SQL » SQL & PL/SQL » SP2-0310
SP2-0310 [message #228538] Tue, 03 April 2007 05:45 Go to next message
parasuramchekuri
Messages: 32
Registered: March 2007
Location: vishakapatnam
Member
hi all
i want to run script as a .sql file
i have to kept the scripts.sql file in bin directory
and i typed the command in sql al given below
SQL> @SCRIPTS.SQL
AND IT SHOWS THE FOLLOWING ERROR
SP2-0310: unable to open file "SCRIPTS.SQL"
How to rectify this error
Thanks in Advance..
Ram...
Re: SP2-0310 [message #228539 is a reply to message #228538] Tue, 03 April 2007 05:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use full file path (such as @c:\oracle\this_and_that\yourfile.sql)
Re: SP2-0310 [message #228556 is a reply to message #228538] Tue, 03 April 2007 06:16 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just to add (you have not provided your OS info),
in unix filenames are case sensitive
Previous Topic: Need inputs for inserting data in DB from .dat file.
Next Topic: Display results in one query with different WHERE conditions
Goto Forum:
  


Current Time: Thu Dec 08 16:27:22 CST 2016

Total time taken to generate the page: 0.06241 seconds