Hi!
I'm experiencing a weird problem here... I'm about to move one user's object from the development box to a test box. The user's rights on both boxes are identical.
What I do is this:
- export user (using exp) from development. Works flawlessly.
- import user into the other box (user setup and tablespaces are identical)
An I get the following errors which doesn't make a lot of sense to me...
...
. . importing table "TABELLEN" 37 rows imported
. . importing table "TABELLEN_ZUORDNUNGEN" 28 rows imported
. . importing table "TMP$TEST" 1 rows imported
. . importing table "TMP_FUNKTIONS_PARAMETER" 0 rows imported
. . importing table "TMP_FUNKTIONS_SPALTEN" 0 rows imported
. . importing table "USEREXIT" 5 rows imported
. . importing table "USEREXIT_TYPE" 3 rows imported
. . importing table "ZYKLUS" 7 rows imported
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_BNGR_FK" FOREIGN"
" KEY ("BNGR_ID") REFERENCES "BENUTZER_GRUPPEN" ("ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
IMP-00017: following statement failed with ORACLE error 2270:
"ALTER TABLE "BENUTZER_GRUPPEN_ZUORD" ADD CONSTRAINT "BNGRZ_OW_FK" FOREIGN K"
"EY ("OW_ID") REFERENCES "OWNER" ("ID") ENABLE NOVALIDATE"
IMP-00003: ORACLE error 2270 encountered
ORA-02270: no matching unique or primary key for this column-list
...
Any ideas why this is happening?
This is 8.1.7 on Sun Solaris.
Thanks,
Helmut