Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid objects after running catrepr.sql
I think there is a script $ORACLE_HOME/rdbms/admin/utlrp.sql that you need
to run which will recompile all objects .
- Sathish
"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
> ------------------------------ ------------------------------ ------------
--Received on Thu Sep 06 2001 - 19:59:00 CDT
> -
> 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
>
>
>