|
[oracle-l]
||
[Date Prev]
[03-2004 Date Index]
[Date Next]
||
[Thread Prev]
[03-2004 Thread Index]
[Thread Next]
Re: Statspack error : ORA-06564: object HTP_PERFSTAT.STATSPACK doesnot exist
- From: vidya kalyanaraman <vidya.kalyanaraman@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 01 Mar 2004 14:33:27 +0530
Hi
Server: HP-UX
Oracle Ver: 9.2.0.4 64 bit
Sorry I missed this info in my previous post.
Thanks
Vidya
vidya kalyanaraman wrote:
Hi All
While trying to use statspack to generate snaps, got the following
error.
$sqlplus perfstat/perfstat
SQL> execute statspack.snap
BEGIN statspack.snap; END;
*
ERROR at line 1:
ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist
ORA-06512: at "SYS.DBMS_UTILITY", line 114
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 45
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 53
ORA-06512: at "PERFSTAT.STATSPACK", line 2708
ORA-06512: at line 1
Please note that spcreate.sql did not throw any error. Object
STATSPACK is in valid state in 'PERFSTAT' schema but in invalid state
for 'HTP_PERFSTAT' schema.
Could not compile the body, because of 1353/16 PL/SQL: ORA-00942:
table or view does not exist error.
Any idea why this package is not getting compiled? We are totally
lost as the output file has not thrown any error. Do I have to
explicitly grant privileges to HTP_PERFSTAT schema?
TIA
Vidya
|
|
