Error 0310
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us p2-0310 unable to open file linux Learn more about Stack Overflow the company Business Learn more about hiring developers
Sp2 0310 Unable To Open File In Shell Script
or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow sp2 0310 unable to open file sql in windows Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up SP2-0310: unable to open file “dba_files_all.sql” up vote
Sp2-0310: Unable To Open File: Sql Developer
0 down vote favorite Please advise , @dba_files_all --- SP2-0310: unable to open file "dba_files_all.sql"-- is not working sqlplus share|improve this question asked Jul 26 '15 at 8:27 Jaad 1015 add a comment| 3 Answers 3 active oldest votes up vote 0 down vote 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 sp2 0310 unable to open file sql in unix path. SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. share|improve this answer answered Jul 26 '15 at 8:31 Itz Raghu 199214 not working as well SP2-0310: unable to open file "/u01/app/oracle./scripts/myfile.sql" –Jaad Jul 26 '15 at 8:40 if the file does not exist in current directory or permissions are not correct, then you'll get this error –Itz Raghu Jul 26 '15 at 8:44 How can I over come this issue? I need to view all files after migrating from File system to ASM. –Jaad Jul 29 '15 at 8:38 This is a verbatim copy-pasta from dba-oracle.com/t_sp2_0310_unable_to_open_file.htm –Rondo Sep 28 at 23:04 add a comment| up vote 0 down vote 1. use absolutely path like: /u01/app/oaracle/test.sql 2. check if the path if the script exists ls -l /u01/app/oaracle/test.sql share|improve this answer answered Jul 25 at 10:09 tzJacky 11 add a comment| up vote 0 down vote All the answers so far imply that absolute paths are required. That aren't. Relative paths in sql is pretty universal in sql tools. Sometimes, you have to configure a lost default configuration such as in the case of SQLDeveloper as
#317497] Thu, 01 May 2008 12:18 y2raza Messages: 34Registered: March 2008 Member i have been trying to run the sql script but to no
Change Directory In Sqlplus
avail each time i try it gives me SP2-0310 error, please help
How To Run Sql Script In Sqlplus
i have tried giving the full path & with @ but to no avail???? thanx in advance sp2-0640 not connected Report message to a moderator Re: SP2-0310 error [message #317498 is a reply to message #317497] Thu, 01 May 2008 12:35 joy_division Messages: 4618Registered: February 2005 http://stackoverflow.com/questions/31635032/sp2-0310-unable-to-open-file-dba-files-all-sql Location: East Coast USA Senior Member filename are case sensitive in unix and linux. Report message to a moderator Re: SP2-0310 error [message #317499 is a reply to message #317497] Thu, 01 May 2008 12:36 Michel Cadot Messages: 63853Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Why don't you tell us the http://www.orafaq.com/forum/t/101689/ full message? What is SP2-0310? Why don't you post what you tried to do when you got this error? Regards Michel Report message to a moderator Re: SP2-0310 error [message #317501 is a reply to message #317497] Thu, 01 May 2008 12:39 Michel Cadot Messages: 63853Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Found it: Quote:SP2-0310 unable to open file file_name Cause: Unable to open the specified file. Action: Check and make sure the file name is valid. Regards Michel Report message to a moderator Re: SP2-0310 error [message #317504 is a reply to message #317497] Thu, 01 May 2008 13:12 y2raza Messages: 34Registered: March 2008 Member SQL> start awrddrpt.sql SP2-0310: unable to open file "awrddrpt.sql" Report message to a moderator Re: SP2-0310 error [message #317505 is a reply to message #317497] Thu, 01 May 2008 13:25 BlackSwan Messages: 24930Registered: January 2009 Location: SoCal Senior Member SQL> start awrddrpt.sql SQL> ! ls -l awrddrpt.sql if the file does not ex
Unable to open file If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start http://www.dbasupport.com/forums/showthread.php?14270-SP2-0310-Unable-to-open-file viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: SP2-0310 Unable to open file Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 08-07-2001,04:16 PM #1 richardana View Profile View Forum Posts Junior Member Join Date Jul 2001 Posts 45 Hi all, I find a script that unable to I have copied and saved on the notepad as all files with extension .sql. (REPORT.sql) when running the script on the sqlplus, i was getting the following error. SQL> @report.sql SP2-0310: Unable to open file "report.sql" Can someone tell me what that error is about? and how to go by correcting it? Thanks Richard Reply With Quote 08-07-2001,04:20 PM #2 jrpm View Profile View Forum Posts Senior Member Join Date Apr 2001 Location Louisville KY unable to open Posts 295 You might check for a 'report.sql.txt'. I have had that happen a couple of times. Joseph R.P. Maloney, CSP,CDP,CCP 'The answer is 42' Reply With Quote 08-07-2001,04:43 PM #3 santoshym View Profile View Forum Posts Advisor Join Date Mar 2001 Posts 635 Hi Richard, Make sure you have save ur file in ORACLE_HOME/bin directory becuase by default it looks into this directory for the file you might have saved it in a differnt directory Regards, Santosh Reply With Quote 08-07-2001,05:02 PM #4 hemanr View Profile View Forum Posts Senior Member Join Date May 2001 Location Atlanta US Posts 262 Search for the location of the file. It may be in the Oracle Bin directory. Then c:> sta (full path)\report.sql or else copy the file to the c:> then C:> sta report.sql (or @report.sql) If you do not specify a path while saving it gets saved to the Oracle bin directory by default. Hemant Reply With Quote Quick Navigation Oracle Database Administration Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Oracle Forums Oracle Database Administration Oracle Applications DBA Oracle Development Oracle Certification Oracle : How To Oracle Careers Oracle Positions Available Oracle Job Wanted Archives Forum Archives Other Feedback and Questions regarding the forums Obfuscation Unlimited « Previous Thread | Next Thread » Posting Pe