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
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: http://stackoverflow.com/a/24003529/442968 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.
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,
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"
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