Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> VERY URGENT -- Catrep.sql
Hi all
After executing the catrep.sql still lot of packages are seems to
be invalid.
After that I executed the
r0703040.sql
utlrp.sql which are optional sql's recomended by the oracle
corporation
to rerun the packages which are in a invalid mode
Even after that 76 rows are in the invalid status.
Please give me some tips to solve this problem.
FYI
OBJECT_NAME OBJECT_TYPEReceived on Thu Nov 09 2000 - 06:12:11 CST
------------------------------ ------------------
NameFromLastDDL FUNCTION DBMSOBJG PACKAGE DBMSOBJG PACKAGE BODY DBMSOBJG2 PACKAGE DBMSOBJG2 PACKAGE BODY DBMSOBJGWRAPPER PACKAGE BODY DBMS_ASYNCRPC_PUSH PACKAGE BODY DBMS_DEFER PACKAGE BODY DBMS_DEFERGEN PACKAGE DBMS_DEFERGEN PACKAGE BODY DBMS_DEFERGEN_AUDIT PACKAGE OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_DEFERGEN_AUDIT PACKAGE BODY DBMS_DEFERGEN_INTERNAL PACKAGE DBMS_DEFERGEN_INTERNAL PACKAGE BODY DBMS_DEFERGEN_LOB PACKAGE DBMS_DEFERGEN_LOB PACKAGE BODY DBMS_DEFERGEN_PRIORITY PACKAGE BODY DBMS_DEFERGEN_RESOLUTION PACKAGE DBMS_DEFERGEN_RESOLUTION PACKAGE BODY DBMS_DEFERGEN_UTIL PACKAGE DBMS_DEFERGEN_UTIL PACKAGE BODY DBMS_DEFERGEN_WRAP PACKAGE OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_DEFERGEN_WRAP PACKAGE BODY DBMS_DEFER_IMPORT_INTERNAL PACKAGE BODY DBMS_DEFER_INTERNAL_QUERY PACKAGE BODY DBMS_DEFER_INTERNAL_SYS PACKAGE BODY DBMS_DEFER_QUERY PACKAGE BODY DBMS_DEFER_REPCAT PACKAGE BODY DBMS_DEFER_SYS PACKAGE DBMS_DEFER_SYS PACKAGE BODY DBMS_DEFER_SYS_PART1 PACKAGE BODY DBMS_INTERNAL_REPCAT PACKAGE BODY DBMS_MAINT_GEN PACKAGE BODY OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_OFFLINE_INTERNAL PACKAGE BODY DBMS_OFFLINE_OG PACKAGE BODY DBMS_OFFLINE_SNAPSHOT PACKAGE BODY DBMS_OFFLINE_UTL PACKAGE DBMS_OFFLINE_UTL PACKAGE BODY DBMS_RECTIFIER_DIFF PACKAGE BODY DBMS_RECTIFIER_FRIENDS PACKAGE BODY DBMS_REPCAT PACKAGE BODY DBMS_REPCAT_ADMIN PACKAGE BODY DBMS_REPCAT_CACHE PACKAGE DBMS_REPCAT_CACHE PACKAGE BODY OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_CONF PACKAGE BODY DBMS_REPCAT_DECL PACKAGE DBMS_REPCAT_DECL PACKAGE BODY DBMS_REPCAT_FLA PACKAGE DBMS_REPCAT_FLA PACKAGE BODY DBMS_REPCAT_FLA_MAS PACKAGE BODY DBMS_REPCAT_FLA_UTL PACKAGE DBMS_REPCAT_FLA_UTL PACKAGE BODY DBMS_REPCAT_INSTANTIATE PACKAGE BODY DBMS_REPCAT_INTERNAL PACKAGE BODY DBMS_REPCAT_MAS PACKAGE OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_MAS PACKAGE BODY DBMS_REPCAT_MIG PACKAGE BODY DBMS_REPCAT_MIG_INTERNAL PACKAGE BODY DBMS_REPCAT_RPC PACKAGE BODY DBMS_REPCAT_RPC_UTL PACKAGE BODY DBMS_REPCAT_SNA PACKAGE DBMS_REPCAT_SNA PACKAGE BODY DBMS_REPCAT_SNA_UTL PACKAGE DBMS_REPCAT_SNA_UTL PACKAGE BODY DBMS_REPCAT_UNTRUSTED PACKAGE DBMS_REPCAT_UNTRUSTED PACKAGE BODY OBJECT_NAME OBJECT_TYPE
------------------------------ ------------------
DBMS_REPCAT_UTL PACKAGE DBMS_REPCAT_UTL PACKAGE BODY DBMS_REPCAT_UTL2 PACKAGE BODY DBMS_REPCAT_UTL3 PACKAGE DBMS_REPCAT_UTL3 PACKAGE BODY DBMS_REPCAT_UTL4 PACKAGE DBMS_REPCAT_UTL4 PACKAGE BODY DBMS_REPCAT_VALIDATE PACKAGE BODY DBMS_REPUTIL PACKAGE BODY