I'm getting this error message while doing my import.
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "ACCOUNT_DATA_ERROR_LOG" ADD CONSTRAINT "FK_ADEL_AI" FOREIGN KE"
"Y ("ACCOUNT_ITEM_ID") REFERENCES "ACCOUNT_ITEMS" ("ACCOUNT_ITEM_ID") ENABLE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
I did check the primary key and foreign key values. They both seem to be the same.
How can I overcome this error and do my import.
thanks a lot
09-05-2001, 12:32 PM
Can you use the
CONSTRAINTS = N
in the parameter file?
09-05-2001, 01:35 PM
Verify that the primary key on "ACCOUNT_ITEMS" ("ACCOUNT_ITEM_ID") exists. Not the values, but the actual key.
09-06-2001, 01:32 AM
Oracle imports constraints and triggers in the end (after row data).
I think the problem is that the data required for referencing (parent table) is being imported after the child table.
I would suggest run first import with rows=n
Second run of import with rows=y and ignore=y to import rows after the table definition and constraints are in place.
[Edited by Raminder on 09-06-2001 at 01:37 AM]
09-06-2001, 04:34 AM
Thanks for the help. I was going to try with constraints =n and later add the constraints.
Now maybe, I'll try out what raminder has just mentioned.
09-06-2001, 05:36 AM
I did try with rows=n first, that worked fine. But te second import with rows=y and ignore=y gave me errors ora-02291 integrity constraint violated- parent key not found.
When I tried with constraints=n,
It does the import, but why does it try to enable the constraints at the end even if I put constarints=n.
Is there any option of telling the import not to enable constraints at the end.