@utlu102s.sql results INVALID database status
we used 10.2.0.4 oracle dbua utility to upgrade database, and some of db components are left INVALID.
how to make them compile.
SQL> @utlu102s.sql
.
Oracle Database 10.2 Upgrade Status Utility 09-02-2009 19:01:50
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:51:18
.
Total Upgrade Time: 00:53:20
PL/SQL procedure successfully completed.
SQL>
SQL> select owner, object_name, object_type, status from dba_objects where status <> 'VALID' and owner='SYS';
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------- -------------------
STATUS
-------
SYS DBMS_AQ_SYS_EXP_INTERNAL PACKAGE BODY
INVALID
SYS DBMS_AQ_IMPORT_INTERNAL PACKAGE BODY
INVALID
SYS DBMS_AQ_SYS_IMP_INTERNAL PACKAGE BODY
how to make them compile.
SQL> @utlu102s.sql
.
Oracle Database 10.2 Upgrade Status Utility 09-02-2009 19:01:50
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:51:18
.
Total Upgrade Time: 00:53:20
PL/SQL procedure successfully completed.
SQL>
SQL> select owner, object_name, object_type, status from dba_objects where status <> 'VALID' and owner='SYS';
OWNER OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------------- -------------------
STATUS
-------
SYS DBMS_AQ_SYS_EXP_INTERNAL PACKAGE BODY
INVALID
SYS DBMS_AQ_IMPORT_INTERNAL PACKAGE BODY
INVALID
SYS DBMS_AQ_SYS_IMP_INTERNAL PACKAGE BODY
0