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

From: Libal, Ivo <ivo.libal_at_knapp-systems.com>
Date: Tue, 18 Jul 2000 10:48:11 +0200
Message-Id: <10562.112242@fatcity.com>

Maybe you should install tables without any constraints,triggers ... - = they
will be installed and enabled after insert of data by import - there = should
be no constraint violations.
Ivo Libal

> -----Urspr=FCngliche Nachricht-----
> Von: Rahul [SMTP:rahul_at_ratelindo.co.id]
> Gesendet am: Dienstag, 18. Juli 2000 11:24
> An: Multiple recipients of list ORACLE-L
> Betreff: how to IMP lookup tables first, and referencing tables later
> ?

>=20

> 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 ??

>=20

> TIA

>=20

> Rahul
> =20
> --=20
> Author: Rahul
> INET: rahul_at_ratelindo.co.id

>=20


> 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 - 03:48:11 CDT