Database Administration (MOSC)

MOSC Banner

How to validate objects after running catalog.sql, catproc.sql, and utlrp.sql?

edited Aug 10, 2009 9:18AM in Database Administration (MOSC) 8 commentsAnswered ✓
Hi,

 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

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