Home » SQL & PL/SQL » SQL & PL/SQL » SP2-0310 error (Oracle,10gR2,Ubuntu Linux 7.10)
SP2-0310 error [message #317497] Thu, 01 May 2008 12:18 Go to next message
y2raza
Messages: 34
Registered: 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, please help i have tried giving the full path & with @ but to no avail????

thanx in advance
Re: SP2-0310 error [message #317498 is a reply to message #317497] Thu, 01 May 2008 12:35 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
filename are case sensitive in unix and linux.
Re: SP2-0310 error [message #317499 is a reply to message #317497] Thu, 01 May 2008 12:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account 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
Re: SP2-0310 error [message #317501 is a reply to message #317497] Thu, 01 May 2008 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account 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
Re: SP2-0310 error [message #317504 is a reply to message #317497] Thu, 01 May 2008 13:12 Go to previous messageGo to next message
y2raza
Messages: 34
Registered: March 2008
Member
SQL> start awrddrpt.sql
SP2-0310: unable to open file "awrddrpt.sql"
Re: SP2-0310 error [message #317505 is a reply to message #317497] Thu, 01 May 2008 13:25 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: 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

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select sysdate from dual;

SYSDATE
---------------
01-MAY-08

SQL> @time

Session altered.

SQL> select sysdate from dual;

SYSDATE
-------------------
2008-05-01 11:28:12

SQL> 

[Updated on: Thu, 01 May 2008 13:28] by Moderator

Report message to a moderator

Re: SP2-0310 error [message #317506 is a reply to message #317497] Thu, 01 May 2008 13:39 Go to previous messageGo to next message
y2raza
Messages: 34
Registered: March 2008
Member
the file resides in rdbms/admin directory , please elaborate

thank you

Re: SP2-0310 error [message #317507 is a reply to message #317506] Thu, 01 May 2008 13:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check your SQLPATH variable.
By default it is ?/dbs or ?/database or ?/sql... depending on the version and OS, but NEVER ?/rdbms/admin.
Give the full path if you don't want this error.

Regards
Michel
Re: SP2-0310 error [message #317508 is a reply to message #317504] Thu, 01 May 2008 13:45 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
y2raza wrote on Thu, 01 May 2008 11:12
SQL> start awrddrpt.sql


based upon the above command SQL*Plus will only look for the file in the current directory.

If the file resides in a directory other than your current directory, then you must provide a valid relative or absolute pathname to the file to be invoked.

[Updated on: Thu, 01 May 2008 13:46] by Moderator

Report message to a moderator

Re: SP2-0310 error [message #317509 is a reply to message #317497] Thu, 01 May 2008 13:52 Go to previous message
y2raza
Messages: 34
Registered: March 2008
Member
oh thanx it worked than you very much
Previous Topic: Concat function
Next Topic: look for missing record from the same table
Goto Forum:
  


Current Time: Sun Dec 04 22:44:05 CST 2016

Total time taken to generate the page: 0.10040 seconds