RE: Weid exp/imp problem

[Karniotis, Stephen]

Title: Weid exp/imp problem

Helmut:     This could be due to the fact that constraints on those tables have not been defined yet.  Since tables are imported in Alpha order, I would suggest performing a no-data import after this one is complete.   Thank You   Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct:          (248) 865-4350 Mobile:          (248) 408-2918 Email:             [EMAIL PROTECTED] Web:              www.compuware.com     -----Original Message----- From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:25 AM To: Multiple recipients of list ORACLE-L Subject: Weid exp/imp problem   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