How to fix the Oracle error IMP-00071: Object identifier of imported table mismatches object identifier of existing table?

In this post, you’ll learn more about the Oracle ErrorIMP-00071: Object identifier of imported table mismatches object identifier of existing table with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00071: Object identifier of imported table mismatches object identifier of existing table

Reason for the Error IMP-00071: Object identifier of imported table mismatches object identifier of existing table

An attempt was made to import data into a table that was recreated under a different object identifier than the object identifier used for the exported object table. Under this situation, REF’s to this table that are contained within the dump file will also be invalid.

How to fix the Error IMP-00071: Object identifier of imported table mismatches object identifier of existing table ?

You can fix this error in Oracle by following the below steps

Drop the offending object table prior to import.