Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Invalid Objects

Posted on 2014-03-05
3
388 Views
Last Modified: 2014-03-05
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?
0
Comment
Question by:xoxomos
3 Comments
 
LVL 20

Expert Comment

by:flow01
ID: 39907174
in sqlplus
show error view SYSTEM.GV_$LOADCSTAT VIEW

else check the dba_errors/all_errors view for more information
0
 
LVL 23

Accepted Solution

by:
David earned 300 total points
ID: 39907233
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:
0
 

Author Closing Comment

by:xoxomos
ID: 39907530
Mil gracias
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question