How to fix the Oracle error EXP-00086: Primary key REFs in table “string”may not be valid on import?

In this post, you’ll learn more about the Oracle ErrorEXP-00086: Primary key REFs in table “string”may not be valid on import with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error EXP-00086: Primary key REFs in table “string”may not be valid on import ?

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

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