RE: Weid exp/imp problem

From: Christian Trassens <ctrassens_at_yahoo.com>
Date: Wed, 19 Dec 2001 03:49:56 -0800
Message-ID: <F001.003DFD11.20011219033025@fatcity.com>

You can handle this by two ways. The first is running the imp in two times. And the second imp with rows=n and ignore=y.

On the other hand, you can create all the objects with the constraints INITIALLY DEFERRED. With the precaution that you can not undo the mode of the constraint with an alter table command. Therefore, you could do it with INITIALLY IMMEDIATE the default mode, but it would hurt the performance of the import. To get the stmts of creation, you can run the imp with show=y and get all the stmts or if you have 9i you could use DBMS_METADATA package.

Regards.
--- kranti pushkarna <kranti_pushkarna_at_staarship.com> wrote:
> 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-----
> Sent: Wednesday, December 19, 2001 1:55 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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
>
>

ENG. Christian Trassens
Senior DBA
ctrassens_at_yahoo.com
christian_trassens_at_yahoo.es
Phone : +34-699240979
+34-649824704

Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christian Trassens
  INET: ctrassens_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Dec 19 2001 - 05:49:56 CST