Weid exp/imp problem

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Wed, 19 Dec 2001 00:54:04 -0800
Message-ID: <F001.003DFB34.20011219002520@fatcity.com>

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 Received on Wed Dec 19 2001 - 02:54:04 CST