Database Administration (MOSC)

MOSC Banner

DB invalids huge in number

edited May 11, 2013 11:55PM in Database Administration (MOSC) 13 commentsAnswered
Hi ,

We have 156 invalds in the source DB,Attahced is the list and the below is a sample for the same.

We actually tried running catrpoc and then canclled the process,this has led to many invalids,Running utlrp.sql and manually compiling invalids did not help.

Plz advice.

KU$_ROLE_VIEW                                                                                                                    VIEW                SYS
KU$_SCHEMA_CALLOUT_VIEW                                                                                                          VIEW                SYS
KU$_SEQUENCE_VIEW                                                                                                                VIEW                SYS
KU$_SPIND_STATS_VIEW                                                                                                             VIEW                SYS
KU$_SYSCALLOUT_VIEW                                                                                                              VIEW                SYS
KU$_TAB_CACHE_STATS_VIEW                                                                                                         VIEW                SYS
KU$_TAB_COL_VIEW                                                                                                                 VIEW                SYS
KU$_TAB_ONLY_STATS_VIEW                                                                                                          VIEW                SYS
KU$_TAB_STATS_VIEW                                                                                                               VIEW                SYS

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center