Full Import into Oracle9i or Higher: ORA-2270 on Tables DEF$_CALLDEST and/or REPCAT$_REPSCHEMA (Doc ID 341834.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Enterprise Manager for RDBMS - Version: 9.0.1 to 10.2.0
Oracle Server - Enterprise Edition - Version: 9.0.1 to 10.2.0
Oracle Server - Personal Edition - Version: 9.0.1 to 10.2.0
Oracle Server - Standard Edition - Version: 9.0.1 to 10.2.0
This problem can occur on any platform.

Symptoms

A full database import with IGNORE=Y from an Oracle8i 8.1.7.4.0 or lower release source database into an Oracle9i 9.0.1.1.1 or higher release target database errors with:

...
IMP-00017: following statement failed with ORACLE error 2270: "ALTER TABLE "DEF$_CALLDEST" ADD CONSTRAINT "DEF$_CALL_DESTINATION" FOREIGN " "KEY ("DBLINK") REFERENCES "DEF$_DESTINATION" ("DBLINK") ENABLE NOVALIDATE" IMP-00003: ORACLE error 2270 encountered ORA-02270: no matching unique or primary key for this column-list

and:

IMP-00017: following statement failed with ORACLE error 2270:
 "ALTER TABLE "REPCAT$_REPSCHEMA" ADD CONSTRAINT "REPCAT$_REPSCHEMA_DEST" FOR"
 "EIGN KEY ("DBLINK") REFERENCES "DEF$_DESTINATION" ("DBLINK") ENABLE NOVALID"
 "ATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
...

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