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.
Any help appreciated.
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
This is a known isue (bug?) in some 8i releases. Check note 203317.1 on Metalink.
If you don't have access to Metalink, do the following:
Connect as SYS using svrmgrl (don't use SQL*Plus!!!) and rerun the following scripts:
1)catrepr.sql (Removes Replication related objects)
2)catrep.sql (Creates Replication related objects)
3)utlrp.sql (Recompile Invalid PL/SQL modules).
The basic reason for this problem is the fact that during the database creation some replication packages (that are also used by the IMPort) were created incomplete and invalid, and they can't be recompiled. And the culprit of the problem is the SQL*Plus, in which those scripts were run during instalation (just like suggested by the manuals), but its deffault buffer was too small for the creation of those packages. Using svrmgrl when creating them avoids those problems.
Jurij Modic ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?