oracle import failing

[umeman]

DBA's

I get the following error when I try to do an import.

I reran catexp.sql and utlrp.sql as sys however I still get
the same error.

I am running Oracle 8i (8.1.7.4) on solaris

Any help appreciated.
Thanks
-u-

IMP-00017: following statement failed with ORACLE error 4068:
"BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068: existing state of packages has been discarded
ORA-04063: package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 95
ORA-06512: at line 1
IMP-00000: Import terminated unsuccessfully

 

[karluk]

Your error messages indicate that you have invalid replication packages. You seem to be on the right track in running utlrp.sql, but Metalink says that this script only recompiles the packages. You should really drop and recreate them first in order to eliminate whatever errors the packages might contain. Metalink suggests running the following scripts.

catrepr.sql (to remove the replication packages)
catrep.sql (to recreate the replication packages)
utlrp.sql (to recompile any invalid packages)

 

[umeman]

Hi

Thank you very much, this worked out perfectly

-u-