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.
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.
Do you want to learn Oracle SQL, then read the following articles.
2,607 views last month, 4 views today