Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

sqlplus

Please advise. This SQLPlus call:

SQL > @dba_files_all 

...is not working.

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

How can I resolve the error?

like image 899
Jaad Avatar asked Jul 26 '15 08:07

Jaad


People also ask

How do I run a SQL script from Sqlplus command line in Windows?

Answer: To execute a script file in SQLPlus, type @ and then the file name. The above command assumes that the file is in the current directory. (ie: the current directory is usually the directory that you were located in before you launched SQLPlus.) This command would run a script file called script.

How do I change directory in SQL Plus?

You have to use the "cd" command in windows BEFORE running the 'sqlplus' command. The cd should change the directory to the one which contains the script to run.


1 Answers

You need to provide the path of the file as string.

Put the path in double quotes and it will work.

For example:

@"C:\Users\Arpan Saini\Zions R2\Reports Statements and Notices\Patch\08312017_Patch_16.2.3.17\DB Scripts\snsp.sql";
like image 124
Arpan Saini Avatar answered Oct 01 '22 18:10

Arpan Saini