Invalid objects after running catrepr.sql

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 Thu Sep 06 2001 - 16:58:47 CDT