RE: how to IMP lookup tables first - last

List,
based on you suggestions....

1) disable all FK's
2) disable all check constraints...
3) import with constraints=N, ignore=Y, indexes=N
4) enable everything again...

thanks you list...

Rahul

> ----------
> From: Kimberly.smith_at_gmd.fujitsu.com[SMTP:Kimberly.smith_at_gmd.fujitsu.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, July 18, 2000 11:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: how to IMP lookup tables first, and referencing tables later ?
>
> Disable all your foreign keys on the tables.
>
> -----Original Message-----
> Sent: Tuesday, July 18, 2000 2:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> List,
> i have a 1.2GB dmp file which i want to imp into my new instance (8i)
> i have PRE-created all the tables...
> the problem is that IMP imports tables in A-Z sequence !! and rows are
> rejected because of parent key not found..
> one solution is to do an IMP twice.. but this takes a long time...
> any other ideas ??
>
> TIA
>
> Rahul
>
> --
> Author: Rahul
> INET: rahul_at_ratelindo.co.id
>
> 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).
>
> --
> Author:
> INET: Kimberly.smith_at_gmd.fujitsu.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 Jul 19 2000 - 00:07:34 CDT