Hi,

I got ” SP2-0310 unable to open file ” error in Oracle database during invoke any SQL File.

 

 

SP2-0310 unable to open file

 

Details of error are as follows.

SQL> @utlrp.sql
SP2-0310: unable to open file "utlrp.sql"
SQL> 


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.

 

 

SP2-0310

The SP2-0310 unable to open file error is related with the PATH of Related sql file.

To solve this error, go to the related directory where the file exists and then invoke sqlplus and SQL Command file like ( utlrp.sql ).

 

unable to open file

In our example; utlrp.sql file is under the $ORACLE_HOME/rdbms/admin directory, but we run it under /home/oracle so we got this error.

To solve this error, go to the $ORACLE_HOME/rdbms/admin directory, then run it again.

Or you can run it by using the Full Path of SQL as follows.

 

SQL> @/u01/app/oracle/product/19.0/dbhome_1/rdbms/admin/utlrp.sql

 

 

Do you want to learn Oracle SQL, then read the following articles.

Oracle SQL Tutorials For Beginners – Learn Oracle SQL from scratch with Oracle SQL Online Course