|
-
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"
FOREI"
"GN KEY ("ACTIONID", "ACTIONVERSIONID") REFERENCES "ACTION" ("ACTIONID",
"AC"
"TIONVERSIONID") ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED ENABLE
NOVA"
"LIDATE"
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?
Thanks in advance for any help you can provide!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|