Re: VERY URGENT -- Catrep.sql

Try :
execute dbms_utility.compile.schema ('SCHEMA_NAME')

This will compile all objects in the schema which has the invalid objects. You can find out which objects are invalid and the schema_name by : select object_type, object_name, owner from dba_objects where status='INVALID';

However, one other thought, did you run catalog.sql before you ran catproc.sql? The proper order is catalog, catproc, catexp.

HTH,
Ruth
----- Original Message -----
From: "Suganya" <ukumsu02_at_shafika.vetri.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, November 09, 2000 7:21 AM 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
> _ALL_REPCOLUMN VIEW
>
> 76 rows selected.
>
>
>
> Thanks in advance
> Suganya
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Suganya
> INET: ukumsu02_at_shafika.vetri.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
Received on Thu Nov 09 2000 - 08:32:43 CST