Home > Unable To > Sqlplus Run Script Unable To Open File

Sqlplus Run Script Unable To Open File


With MySQL this works. Also, it is utilized to encode documents and serialize data. share|improve this answer answered Jul 26 '15 at 8:31 Itz Raghu 197214 not working as well SP2-0310: unable to open file "/u01/app/oracle./scripts/myfile.sql" –Jaad Jul 26 '15 at 8:40 You can not post a blank message. have a peek at this web-site

You may have to register before you can post: click the register link above to proceed. Maloney, CSP,CDP,CCP 'The answer is 42' Reply With Quote 08-07-2001,05:43 PM #3 santoshym View Profile View Forum Posts Advisor Join Date Mar 2001 Posts 635 Hi Richard, Make sure you have Just e-mail: and include the URL for the page. All Rights Reserved.SP2-0310: unable to open file "ora_scr_tmp.sql"================================================================================2011-11-22, 13:44:44 SAPINST ORACLE start logging for connect / as sysdba ;CONNECT / AS SYSDBASHUTDOWN [email protected] IMMEDIATESTARTUP MOUNTALTER DATABASE ARCHIVELOG;ALTER DATABASE OPEN;EXITexit;Output of SQL

Sp2-0310 Unable To Open File Sqlplus

Re: SP2-0310: unable to open file "transport.sql" 855496 Apr 21, 2011 8:53 AM (in response to Sunny kichloo) Hi there, Thank you for your reply. Learn more about SAP Q&A. Can a mathematician review my t-shirt design? up vote 3 down vote favorite I'm connected to a server with sql, I did, SQL>@/path/to/file.sql but got an SP2-0310: unable to open file error.

Report message to a moderator Re: SP2-0310: unable to open file [message #435512 is a reply to message #435510] Wed, 16 December 2009 08:47 Michel Cadot Messages: 64178Registered: It may be in the Oracle Bin directory. See shell script below: # EXT=rp_`date +%d%m%y` # extension used for timestamping of files OS_user=`whoami` # os username; used in directory references LOG=/home/silitst/LIST/Logs # Create the log file LOG_FILE=$LOG/edi_`date +%m%d%y`.log; export Sp2-0310: Unable To Open File: Sql Developer Edited by: Sunny kichloo on Apr 21, 2011 1:04 AM Like Show 0 Likes(0) Actions 2.

An Array of Challenges #2: Separate a Nested Array Help, my office wants infinite branch merges as policy; what other options do we have? Sp2 0310 Unable To Open File In Shell Script If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations. If you start sqlplus from a prompt window in c:\ you'll be able to run that script as @query Saludos... Nevertheless, I still tried to call the file using the path of the file but still encountered the same error message.

Sometimes, you have to configure a lost default configuration such as in the case of SQLDeveloper as explained in this answer: share|improve this answer answered Sep 28 at 23:13 Rondo Change Directory In Sqlplus Reply With Quote 07-06-04,10:23 #3 DKG View Profile View Forum Posts Registered User Join Date May 2004 Location BA [ARG] Posts 137 You can always put "host" and press enter within Please guide me. Senior MemberAccount Moderator "/home/silitst/LIST/testfile.sql" must be on the client side and the user executing sqlplus must have read access to it.

Sp2 0310 Unable To Open File In Shell Script

Report message to a moderator Re: SP2-0310: unable to open file [message #435497 is a reply to message #435479] Wed, 16 December 2009 08:03 Michel Cadot Messages: 64178Registered: Could any one help? Sp2-0310 Unable To Open File Sqlplus Feel free to ask questions on our Oracle forum. Sp2 0310 Unable To Open File Sql In Unix Forum Operations by The UNIX and Linux Forums Skip to Content Open navigation Account Settings Notifications Followed Activities Logout Search Your browser does not support JavaScript.

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Check This Out more hot questions question feed lang-sql about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation What exactly does the anonymous JavaScript function f => f do? Reply With Quote Quick Navigation Oracle Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Sp2 0310 Unable To Open File Sql In Windows

Please turn JavaScript back on and reload this page. Relative paths in sql is pretty universal in sql tools. All Rights Reserved.Connected to an idle instance.SP2-0310: unable to open file "run_control.sql"DisconnectedSAPINST: End of output of SQL executing program /oracle/PBW/102_64/bin/sqlplus.SAPINST found errors.SAPINST The current process environment may be found in sapinst_ora_environment.log.2011-11-22, Source 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

share|improve this answer answered Apr 16 '12 at 21:56 DCookie 29.7k85269 add a comment| up vote 1 down vote I'm not sure how to do this in Unix, but if you Sp2-0310 Windows However, when I executed @transport, I got the following error: SP2-0310: unable to open file "transport.sql" Does anyone have any idea where I may have gone wrong? Regards Michel [Updated on: Wed, 16 December 2009 08:04]Report message to a moderator Re: SP2-0310: unable to open file [message #435510 is a reply to message #435497] Wed,

Browse other questions tagged sqlplus or ask your own question.

for example :- c:/scripts/new.sql    2) Ensure from which directory structure you are currently in, example below.. 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. In 4/4 time can I insert a half sized bar in the middle of the piece? How To Run Sql Script In Sqlplus Thanks Richard Reply With Quote 08-07-2001,05:20 PM #2 jrpm View Profile View Forum Posts Senior Member Join Date Apr 2001 Location Louisville KY Posts 295 You might check for a 'report.sql.txt'.

oracle command-line sqlplus share|improve this question edited Apr 17 '12 at 22:13 asked Apr 16 '12 at 20:01 fenerlitk 73151634 add a comment| 4 Answers 4 active oldest votes up vote When hiking, why is the right of way given to people going up? Let’s understand what XML data… Continue Posted by Alvaro Dee on December 7, 2016 at 1:48am Focus More on Intelligent Tasks by Outsourcing Repetitive Ones One of the most valuable assets have a peek here I have created 1 script file with extension ".sql" and am executing like "@ file.sql" at that time getting one error message that is SP2-0310 UNABLE TO OPEN FILE"                   

This tool uses JavaScript and much of it will not work correctly without it enabled. Recently we have upgraded Oracle from 8.0.6. Forum FAQ Calendar Forum Actions Mark Forums Read Quick Links View Site Leaders Who's Online What's New? You may have to register before you can post: click the register link above to proceed.

Ask a question on this topic 9 replies Share & Follow Privacy Terms of Use Legal Disclosure Copyright Trademark Sitemap Newsletter Sever-sort an array Can cheese in hand luggage be mistaken for plastic explosive? SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. Show 2 replies 1.

Rather than rely on a variable, specify the fully-qualified path. share|improve this answer answered Dec 17 '12 at 22:45 Steve 111 1 This doesn't answer OP's question, though. Join Date: Feb 2004 Last Activity: 22 December 2016, 6:14 AM EST Location: NM Posts: 10,891 Thanks: 463 Thanked 990 Times in 920 Posts SP2-310 is sqlplus complaining about not having