How to validate objects after running catalog.sql, catproc.sql, and utlrp.sql?
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm#sthref2953
According to above link, the original imp/exp are not longer supported in 11g. But, in order to migrate the data from 9i using imp/exp I need to run catalog.sql on my 11g database.
After running catalog.sql I counted 51 invalid objects.
After running catproc.sql I counted 638 invalid objects.
After running utlrp.sql I counted 8 invalid objects seen below:
OWNER OBJECT_TYPE OBJECT_NAME
---------- -------------------- -------------------------
ORDSYS PACKAGE BODY ORD_DICOM_ADMIN_PRV
WMSYS PACKAGE BODY LT
WMSYS PACKAGE BODY LTDDL
WMSYS PACKAGE BODY LTRIC