Message-Id: <10675.121548@fatcity.com> From: Suganya Date: Thu, 09 Nov 2000 17:42:11 +0530 Subject: 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_TYPE ------------------------------ ------------------ 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