-
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.
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
-
Did you set ..
IGNORE=Y
MH
I remember when this place was cool.
-
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?
-
if you run cartepr you will also have to rerun catproc as well, cartepr whacks some objects created by catproc.
steve
I'm stmontgo and I approve of this message
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|