I am trying to import from one user (TEST) to another (TEST2). Everything
works okay, except for the following error msg received when trying to
import foreign keys:
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "ACTIONPROPERTY" ADD CONSTRAINT "FKACTION_ACTIONPROPERTY"
"GN KEY ("ACTIONID", "ACTIONVERSIONID") REFERENCES "ACTION" ("ACTIONID",
"TIONVERSIONID") ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED ENABLE
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
I get this for all foreign keys that it tries to import. What really puzzles
me is that I did a query to see if the primary keys had been imported to the
TEST2 schema and they are all there. Any ideas as to what is going on?
OK....still having problems. This is what I've done:
1. Run import with indexfiles so that it creates a script for creating the indexes and constraints.
2. Run import for tables only....set indexes=N and constraints=N.
3. Run indexfile script in SQL*Plus to create indexes and enable constraints.
Result: I received the same error as in my original post, plus I am also receiving ORA -02430: cannot enable constraint (constraint_name) - no such constraint.
I understand why I receive the ORA-02430 on foreign keys - they are not being created because of ORA-02270 msg reported in the original post. But, I do not understand why I am receiving the ORA-02270, or the ORA-02430 for primary keys. When I query dba_indexes all primary keys are there and have a status of VALID.
I am STILL struggling with this one.....it may be elementary, but, if it is, I have sure missed something. In addition to above, I have checked permissions on user doing import and all checks out there.
Does anyone have any ideas that could help me out with this?