IMP-00017: following statement failed with ORACLE error 4068:

[varajan]

Hi,

I am trying to import a dmp file, and get the following error message. Anu clues as to why this message is being received ? and ahat needs to be done to get rid of this ?

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]

I found a reference to this error in Metalink note 112649.1. It appears that DBMS_REPCAT_MIG_INTERNAL has errors in the database you exported from. You are seeing this reflected in the errors you get during import.

Metalink says that this error was most likely caused by running the catalog scripts, catalog.sql catproc.sql and catrep.sql, using SQL*Plus rather than Server Manager. The problem is that SQL*Plus has a smaller buffer than Server Manager. The solution is to rerun the catalog scripts using Server Manager. Then the packages shouldn't be invalid.

 

[varajan]

Karluk,

Thanks for the prompt response.

However, I have one question, is there a order in which these three scripts needs to be excuted ?

 

[karluk]

Do them in the order I listed:

1. catalog.sql
2. catproc.sql
3. catrep.sql

 

[varajan]

Thanks Karluk,

Executing these 3 scripts did the trick !