Invalid SYS Objects Found On 9.2 Before Upgrade To 10.2.0.1 (Doc ID 837667.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.1.0.7
Information in this document applies to any platform.

Goal

We have invalid objects after upgrading database from old releases to 9.2.0.6 as the following:
SYS ACCESSIBLE_TABLES        VIEW 11-Nov-1998
SYS CONSTRAINT_COLUMNS       VIEW 11-Nov-1998
SYS DBA_CROSS_REFS           VIEW 11-Nov-1998
SYS DBA_TAB_AUDIT_OPTS       VIEW 11-Nov-1998
SYS EXUCOLNN                 VIEW 11-Nov-1998
SYS EXUCOL_TEMP              VIEW 11-Nov-1998
SYS USER_CROSS_REFS          VIEW 11-Nov-1998
SYS USER_TAB_AUDIT_OPTS      VIEW 11-Nov-1998
SYS V$LOCKS_WITH_COLLISIONS  VIEW 11-Nov-1998
SYS V$LOCK_ACTIVITY          VIEW 11-Nov-1998
SYS V$LOCK_ELEMENT           VIEW 11-Nov-1998

So, how can validate these objects before upgrade to 10.2.0.1 ?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms