Oracle Sqlplus Error Sp2-0310
Contents |
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! unable to open sql file in sqlplus Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Sp2-0310 Unable To Open File Windows
SP2-0310 unable to open file sp2 0310 unable to open file in shell script tips Oracle Database Tips by Burleson Consulting May 10, 2015 Question: I am trying to execute a SQL*plus file, but I am getting the error: sp2-0310 sp2-0310: unable to open file: sql developer : unable to open file @path /recreate.sqlAnswer: The docs note this on the SP2-0310 error: 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 error occurs when you have not fully-qualified the PATH to the
Sp2 0310 Unable To Open File Sql In Unix
file. Rather than rely on a variable, specify the fully-qualified path. SQL> @/u01/app/oracle./scripts/myfile.sql Else, go to the directory where the file exists and then invoke sqlplus. 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. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher. Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies sp2 0310 unable to open file sql in windows of this site About Us Learn more about Stack Overflow the company change directory in sqlplus Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges
How To Run Sql Script In Sqlplus
Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a http://www.dba-oracle.com/t_sp2_0310_unable_to_open_file.htm minute: Sign up SP2-0310: unable to open file .sql up vote 0 down vote favorite I am calling batch file from my java program which in result execute some .sql files. the batch script is below: set part1= CREATE OR REPLACE DIRECTORY REPORT AS ' set total=%part1%%4'; echo %total% > DIR_REPORT.sql echo exit; >>DIR_REPORT.sql sqlplus %1/%2@%3 @./DIR_REPORT.sql sqlplus %1/%2@%3 @./PACKAGE_SCRIPTv2.sql and my http://stackoverflow.com/questions/20375222/sp2-0310-unable-to-open-file-sql java code is : Runtime run = Runtime.getRuntime(); System.out.println("Start Running the batch file"); Process p = run.exec(new String[]{"cmd.exe","/c", "start", "C:/Users/sony/Documents/NetBeansProjects/CodeReview/src/codereview/install.bat",i,j,m,l}); System.out.println("Completed"); it is giving error :SP2-0310: unable to open file The first file generated using the batch (DIR_REPORT) is being executed but my PACKAGE_SCRIPTv2.sql is not being executed and giving error, please help me what to do. although when a run batch file mannualy from cmd everything works fine... java oracle share|improve this question edited Dec 5 '13 at 12:18 Maurice Perry 24.2k74474 asked Dec 4 '13 at 12:20 user3065757 3915 Do you have permissions to access the file? –Ben Dec 4 '13 at 13:31 Yes I have, but how can i Check that ? –user3065757 Dec 4 '13 at 13:44 If you're on windows right-click on the file then click properties. –Ben Dec 4 '13 at 13:49 I have all the permission, I verified... –user3065757 Dec 4 '13 at 13:52 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote The first script is being created and executed in the cur
#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 avail each time i try it gives me SP2-0310 error, http://www.orafaq.com/forum/t/101689/ please help i have tried giving the full path & with @ but https://scn.sap.com/thread/2083663 to no avail???? thanx in advance 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: 4621Registered: February 2005 Location: East Coast USA Senior Member filename are case sensitive in unix and linux. Report message to a unable to moderator Re: SP2-0310 error [message #317499 is a reply to message #317497] Thu, 01 May 2008 12:36 Michel Cadot Messages: 63912Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator Why don't you tell us the 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 unable to open Re: SP2-0310 error [message #317501 is a reply to message #317497] Thu, 01 May 2008 12:39 Michel Cadot Messages: 63912Registered: 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: 24958Registered: January 2009 Location: SoCal Senior Member SQL> start awrddrpt.sql SQL> ! ls -l awrddrpt.sql if the file does not exist in current directory or permissions are not correct, then you'll get this error. CUT & PASTE can be your friend, but only when you actually use them [oracle@amo01dn sql]$ ls -l time.sql -rw-r--r-- 1 oracle oinstall 59 Apr 14 17:53 time.sql [oracle@amo01dn sql]$ sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 1 11:27:39 2008 Cop
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and Collabor