IMPDP Fails With ORA-39083, ORA-02270 Where Source Table Has A Disabled Primary Key Constraint
Last updated on SEPTEMBER 28, 2012
Applies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 to 18.104.22.168 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 28-Sep-2012***
EXPDP does not export disabled primary key constraints. This causes IMPDP to fail with the following errors:
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
Disabled the primary key constraint on the exported table prior to running EXPDP.
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