| Statspack Error [message #366192] |
Fri, 12 December 2008 01:28  |
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  |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
