Re: Statspack error : ORA-06564: object HTP_PERFSTAT.STATSPACK does not exist

From: vidya kalyanaraman <vidya.kalyanaraman_at_oracle.com>
Date: Mon, 01 Mar 2004 14:33:27 +0530
Message-ID: <4042FC5F.4000901@oracle.com>

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
>
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 03:01:03 CST