How to fix the Oracle error IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)?

In this post, you’ll learn more about the Oracle ErrorIMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)

Reason for the Error IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string)

Import failed to locate a base table for a constraint that was defined in the dump file and statistics were not imported.

How to fix the Error IMP-00093: Inconsistency between dumpfile constraint definition for table string with columns (string) ?

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

Check to see if the table and constraint exist. If the table and constraint exist, then report this to Oracle Support Services as an Import internal error.