Home » SQL & PL/SQL » SQL & PL/SQL » Statspack Error
Statspack Error [message #366192] Fri, 12 December 2008 01:28 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

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/dpnlbo [tigger]\$
Re: Statspack Error [message #366195 is a reply to message #366192] Fri, 12 December 2008 01:34 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
I can almost say you are not executing that script from SYS user and you are executing from some other user. X$ are special tables and they are exposed only to sys users by default.

Hopefully from next time you will follow the forum guidelines. I don't know how many times this need to be repeated. Please always copy and paste from the sql*plus prompt and format the code.

Regards

Raj
Re: Statspack Error [message #366206 is a reply to message #366195] Fri, 12 December 2008 02:31 Go to previous messageGo to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Raj,

Still I am getting the same error. I had connected through SYS user previously.
Re: Statspack Error [message #366229 is a reply to message #366206] Fri, 12 December 2008 03:38 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Quote:

Please always copy and paste from the sql*plus prompt and format the code.


Regards

Raj
Previous Topic: rename multiple columns
Next Topic: Can any one help me in tuning this query (merged)
Goto Forum:
  


Current Time: Tue Dec 06 14:25:50 CST 2016

Total time taken to generate the page: 0.10507 seconds