Question: I am trying to execute a
SQL*plus file, but I am getting the error:
sp2-0310 : unable to open file @path
/recreate.sql
Answer: The docs
note this on the SP2-0310 error:
Oracle Error : SP2-0310 unable to open file
Cause: Unable to open the specified file.
Action: Check and make
sure the file name is valid....
The SP2-0310 error occurs when you have not fully-qualified the
PATH to the file. Rather than rely on a variable, specify the
fully-qualified path.
SQL> @/u01/app/oracle./scripts/myfile.sql
Else, go to the directory where the file exists and then invoke
sqlplus.
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
