SP2-0310 error [message #317497] |
Thu, 01 May 2008 12:18  |
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 #317505 is a reply to message #317497] |
Thu, 01 May 2008 13:25   |
 |
BlackSwan
Messages: 26766 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 #317508 is a reply to message #317504] |
Thu, 01 May 2008 13:45   |
 |
BlackSwan
Messages: 26766 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
|
|
|
|