IMPDP Fails With ORA-39083, ORA-02270 Where Source Table Has A Disabled Primary Key Constraint (Doc ID 455311.1)

Last updated on SEPTEMBER 28, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 10.1.0.2 to 11.1.0.6 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***

Symptoms

EXPDP does not export disabled primary key constraints. This causes IMPDP to fail with the following errors:

ORA-39083: Object type REF_CONSTRAINT failed to create with error:
ORA-02270: no matching unique or primary key for this column-list
Failing sql is:
ALTER TABLE "SCOTT"."TEST_TABLE" ADD CONSTRAINT "TEST_FK1" FOREIGN KEY ("COL1") REFERENCES "SCOTT"."TEST_TABLE2" ("COL2") DISABLE

Changes

Disabled the primary key constraint on the exported table prior to running EXPDP.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms