RE: Weid exp/imp problem

[Austin, Steve S]

Title: Weid exp/imp problem

You may need to use consistent=y on the export to ensure that the view for the entire export run is from one snapshot in time.  If your application is busy changing data during the export, then as export moves through the list of tables (alphabetically I think) then you'll get some tables at the beginning of the list from one time, and tables late in the list from another with possible referential problems just as exhibited below.

 

hope this helps,

Steve

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