Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

StatsPack Error

639485Dec 12 2008 — edited Dec 12 2008
Hi,

I am configuring statspack through spcreate.sql and I am getting below error.
The Oracle version is 11g and OS is solaris.

Does Anyone have any solution then please let me know.
... Creating PERFSTAT user
... Installing required packages
... Creating views
create or replace view STATS$X_$KCBFWAIT as select * from X$KCBFWAIT
*
ERROR at line 1:
ORA-00942: table or view does not exist
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64 bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[033]0;u@h: w [tigger]007]/home/... [tigger]\$
Thank you.

Edited by: user636482 on Dec 12, 2008 12:20 AM

Edited by: user636482 on Dec 12, 2008 12:25 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2009
Added on Dec 12 2008
3 comments
1,240 views