I tried recompiling replication packages manually once, and found the
dependencies were so complex that it was easier to rerun the scripts. You
have two main sets of objects that are invalid - views and packages. The
packages MAY be invalid (I haven't looked at the code to prove this) because
the views are invalid, so try running catrepc first to see if that helps.
--
HTH. Additions and corrections welcome.
Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Guang Mei" <gmei_at_proteome.com> wrote in message
news:TgSl7.560$v6.77092_at_news.shore.net...
> Hi,
>
> Oracle 8.0.5.2.0 on Sun box
>
> I was trying to clean up replication option that someone installed before.
>
> I use svrmgrl, login as internal and run
> $ORACLE_HOME/rdbms/admin/catrepr.sql
>
> But after that I got lots of invalid objects, even I re-run
>
> catproc.sql
>
> I also tried to re-compile them but failed.
>
> Any suggestions? TIA.
>
> Here is what I got finally:
>
> SQL> select owner, object_name,object_type from all_objects
> 2 where status='INVALID'
> 3 order by owner desc, object_type desc , object_name;
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> YPD GENEORWORD PACKAGE BODY
> YPD GENEORWORD PACKAGE
> SYSTEM ALL_REPAUDIT_ATTRIBUTE VIEW
> SYSTEM ALL_REPCAT VIEW
> SYSTEM ALL_REPCATLOG VIEW
> SYSTEM ALL_REPDDL VIEW
> SYSTEM ALL_REPGENERATED VIEW
> SYSTEM ALL_REPGENOBJECTS VIEW
> SYSTEM ALL_REPGROUP VIEW
> SYSTEM ALL_REPPRIORITY VIEW
> SYSTEM ALL_REPPRIORITY_GROUP VIEW
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM ALL_REPRESOLUTION_METHOD VIEW
> SYSTEM ALL_REPSCHEMA VIEW
> SYSTEM ALL_REPSITES VIEW
> SYSTEM DBA_REPAUDIT_ATTRIBUTE VIEW
> SYSTEM DBA_REPAUDIT_COLUMN VIEW
> SYSTEM DBA_REPCAT VIEW
> SYSTEM DBA_REPCATLOG VIEW
> SYSTEM DBA_REPCOLUMN VIEW
> SYSTEM DBA_REPCOLUMN_GROUP VIEW
> SYSTEM DBA_REPCONFLICT VIEW
> SYSTEM DBA_REPDDL VIEW
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBA_REPGENERATED VIEW
> SYSTEM DBA_REPGENOBJECTS VIEW
> SYSTEM DBA_REPGROUP VIEW
> SYSTEM DBA_REPGROUPED_COLUMN VIEW
> SYSTEM DBA_REPKEY_COLUMNS VIEW
> SYSTEM DBA_REPPARAMETER_COLUMN VIEW
> SYSTEM DBA_REPPRIORITY VIEW
> SYSTEM DBA_REPPRIORITY_GROUP VIEW
> SYSTEM DBA_REPRESOLUTION VIEW
> SYSTEM DBA_REPRESOLUTION_METHOD VIEW
> SYSTEM DBA_REPRESOLUTION_STATISTICS VIEW
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBA_REPRESOL_STATS_CONTROL VIEW
> SYSTEM DBA_REPSCHEMA VIEW
> SYSTEM DBA_REPSITES VIEW
> SYSTEM DEFCALLDEST VIEW
> SYSTEM DEFTRANDEST VIEW
> SYSTEM REPCAT_GENERATED VIEW
> SYSTEM REPCAT_REPCAT VIEW
> SYSTEM REPCAT_REPCATLOG VIEW
> SYSTEM REPCAT_REPPROP VIEW
> SYSTEM REPCAT_REPSCHEMA VIEW
> SYSTEM USER_REPAUDIT_ATTRIBUTE VIEW
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM USER_REPAUDIT_COLUMN VIEW
> SYSTEM USER_REPCAT VIEW
> SYSTEM USER_REPCATLOG VIEW
> SYSTEM USER_REPCOLUMN_GROUP VIEW
> SYSTEM USER_REPCONFLICT VIEW
> SYSTEM USER_REPDDL VIEW
> SYSTEM USER_REPGENERATED VIEW
> SYSTEM USER_REPGENOBJECTS VIEW
> SYSTEM USER_REPGROUP VIEW
> SYSTEM USER_REPGROUPED_COLUMN VIEW
> SYSTEM USER_REPKEY_COLUMNS VIEW
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM USER_REPPARAMETER_COLUMN VIEW
> SYSTEM USER_REPPRIORITY VIEW
> SYSTEM USER_REPPRIORITY_GROUP VIEW
> SYSTEM USER_REPRESOLUTION VIEW
> SYSTEM USER_REPRESOLUTION_METHOD VIEW
> SYSTEM USER_REPRESOLUTION_STATISTICS VIEW
> SYSTEM USER_REPRESOL_STATS_CONTROL VIEW
> SYSTEM USER_REPSCHEMA VIEW
> SYSTEM USER_REPSITES VIEW
> SYSTEM DBMSOBJG PACKAGE BODY
> SYSTEM DBMSOBJGWRAPPER PACKAGE BODY
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBMS_ASYNCRPC_PUSH PACKAGE BODY
> SYSTEM DBMS_DEFER PACKAGE BODY
> SYSTEM DBMS_DEFERGEN PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_AUDIT PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_INTERNAL PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_LOB PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_PRIORITY PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_RESOLUTION PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_UTIL PACKAGE BODY
> SYSTEM DBMS_DEFERGEN_WRAP PACKAGE BODY
> SYSTEM DBMS_DEFER_IMPORT_INTERNAL PACKAGE BODY
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBMS_DEFER_INTERNAL_SYS PACKAGE BODY
> SYSTEM DBMS_DEFER_QUERY PACKAGE BODY
> SYSTEM DBMS_DEFER_QUERY_UTL PACKAGE BODY
> SYSTEM DBMS_DEFER_REPCAT PACKAGE BODY
> SYSTEM DBMS_DEFER_SYS PACKAGE BODY
> SYSTEM DBMS_DEFER_SYS_PART1 PACKAGE BODY
> SYSTEM DBMS_MAINT_GEN PACKAGE BODY
> SYSTEM DBMS_OFFLINE_SNAPSHOT PACKAGE BODY
> SYSTEM DBMS_REPCAT_ADMIN PACKAGE BODY
> SYSTEM DBMS_REPCAT_CONF PACKAGE BODY
> SYSTEM DBMS_REPCAT_DECL PACKAGE BODY
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBMS_REPCAT_MAS PACKAGE BODY
> SYSTEM DBMS_REPCAT_RPC PACKAGE BODY
> SYSTEM DBMS_REPCAT_RPC_UTL PACKAGE BODY
> SYSTEM DBMS_REPCAT_SNA PACKAGE BODY
> SYSTEM DBMS_REPCAT_SNA_UTL PACKAGE BODY
> SYSTEM DBMS_REPCAT_UNTRUSTED PACKAGE BODY
> SYSTEM DBMS_REPCAT_UTL PACKAGE BODY
> SYSTEM DBMS_REPUTIL PACKAGE BODY
> SYSTEM DBMSOBJG PACKAGE
> SYSTEM DBMS_DEFERGEN PACKAGE
> SYSTEM DBMS_DEFERGEN_AUDIT PACKAGE
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBMS_DEFERGEN_INTERNAL PACKAGE
> SYSTEM DBMS_DEFERGEN_LOB PACKAGE
> SYSTEM DBMS_DEFERGEN_RESOLUTION PACKAGE
> SYSTEM DBMS_DEFERGEN_UTIL PACKAGE
> SYSTEM DBMS_DEFERGEN_WRAP PACKAGE
> SYSTEM DBMS_DEFER_SYS PACKAGE
> SYSTEM DBMS_REPCAT_DECL PACKAGE
> SYSTEM DBMS_REPCAT_SNA PACKAGE
> SYSTEM DBMS_REPCAT_SNA_UTL PACKAGE
> SYSTEM DBMS_REPCAT_UNTRUSTED PACKAGE
> SYSTEM DBMS_REPCAT_UTL3 PACKAGE
>
> OWNER OBJECT_NAME OBJECT_TYPE
> ------------------------------ ------------------------------ ------------
--
> -
> SYSTEM DBMS_REPCAT_UTL4 PACKAGE
> SYS DEFCALL VIEW
> SYS DEFCALLDEST VIEW
>
> 113 rows selected.
>
> SQL> spool off
>
>
>
Received on Fri Sep 07 2001 - 10:23:11 CDT
