Problem solve
Get help with specific problems with your technologies, process and projects.
Errors during import of a dump file
I'm new to Oracle and I have the following problem. When I try to do an import of a DMP file, I get this error message and I can't do the import. What do I have to do to solve this?
I'm new to Oracle and I have the following problem. When I try to do an import of a DMP file, I get this message and I can't do the import. What do I have to do to solve this?
IMP-00017 following statement failed with Oracle error 1403: "BEGIN SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;" IMP-00003: ORACLE error 1403 encountered ORA-01403: no data found ORA-06512: at "SYS.DBMS_REPCAT_DECL", line 4 ORA-06512: at "SYS.DBMS_REPCAT_DECL", line 25 ORA-06512: at "SYS.DBMS_REPCAT_MIG", line 116 ORA-06512: at line 1 IMP:00000: Import terminated unsuccessfully
I don't know why this happened, please help me.
The most common cause of this error is that you are using the imp utility from a lower Oracle version than what created the dump file.
For instance, the dump file may have been created with the 9.2.0 exp utility but you are using the 8.1.7 imp utility. When importing to a lower version, you should use the lower version exp utility to create the dump file. To fix this problem, recreate the dump file with the lower version exp utility.
Dig Deeper on Oracle database backup and recovery
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments