RE: how to IMP lookup tables first, and referencing tables later

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Tue, 18 Jul 2000 15:39:21 +0530
Message-Id: <10562.112245@fatcity.com>

hi

disable all the constraints and run yr import

Babu Nagarajan
Citibank, Mumbai
#653-5042

          _\\|//_
         (' O-O ')

----ooO-(_)-Ooo----

> -----Original Message-----
> From: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Sent: Tuesday, July 18, 2000 2:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: how to IMP lookup tables first, and referencing tables later
> ?
>
> 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).
Received on Tue Jul 18 2000 - 05:09:21 CDT