Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dump Import Problem

454641Nov 9 2005 — edited Nov 9 2005

Dear All,

I exported the database dump of a 10.1.0 version database from a WIN2K Server machine.The export was successful.

But, now when I am trying to import the above specified backup to the database of the same version (10.1.0) and of the same Operating System (WIN2K Server ) it gives me the below mentioned errors

The first one being:

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

The second one is:

IMP-00017: following statement failed with ORACLE error 2430:
"ALTER TABLE "XXXX" ENABLE CONSTRAINT "FK_XXXX""

Kindly help me out pertaining to this problem.

Best Regards,

Amar

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2005

Added on Nov 9 2005

#general-database-discussions

2 comments

7,344 views