Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> VERY URGENT -- Catrep.sql

VERY URGENT -- Catrep.sql

From: Suganya <ukumsu02_at_shafika.vetri.com>
Date: Thu, 09 Nov 2000 17:42:11 +0530
Message-Id: <10675.121548@fatcity.com>


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
Received on Thu Nov 09 2000 - 06:12:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US