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 <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
