Invalid Objects

xoxomos
xoxomos used Ask the Experts™
on
I'm showing these views as being invalid objects even after i run utlrp.
SYSTEM    GV_$LOADCSTAT VIEW
SYSTEM    V_$LOADTSTAT VIEW
SYSTEM    V_$LOADCSTAT VIEW
SYSTEM    GV_$LOADTSTAT VIEW
How do i find out how to get them valid?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
flow01IT-specialist

Commented:
in sqlplus
show error view SYSTEM.GV_$LOADCSTAT VIEW

else check the dba_errors/all_errors view for more information
Oracle Database Administrator III
Commented:
Flow, sorry, that would not help.

The following dynamic performance views were made obsolete in release 9.2:
GV$ Views               V$ Views
GV$LOADCSTAT       V$LOADCSTAT
GV$LOADTSTAT       V$LOADTSTAT

For more info:

Author

Commented:
Mil gracias

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial