RE: Weid exp/imp problem

[kranti pushkarna]

Title: Weid exp/imp problem

This error is coming because at the time of adding foreign key constraint , referencing primary key is not available.

You can avoid this error by creating a similar schema in the user in which you are taking the import and then import data

with parameter "ignore=Y".

 

 

Kranti

-----Original Message-----
From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 1:55 PM
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