Oracle Error EXP-00086: Primary key REFs in table “string”may not be valid on import

Oracle Error Message

EXP-00086: Primary key REFs in table “string”may not be valid on import

Reason for the Error

The specified table contains primary key REFs which may not be valid in the import database.

Solution

Do not use Export/Import to move Primary key REFs between databases having differing character sets.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...