Q
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.

This was last published in September 2005

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close