Re: how to IMP lookup tables first, and referencing tables

From: Suhen Pather <pathers5_at_telkom.co.za>
Date: Tue, 18 Jul 2000 12:52:44 +0200
Message-Id: <10562.112248@fatcity.com>

Hi

Disable all constraints
and then import

Sequence of import
Table Definition
Table data
Indexes
Constraints

Import enables constraints last so if you disable all constraints and then = import you can import all your data without violating any constraints.

Regards
$uhen

>>> rahul_at_ratelindo.co.id 07/18/00 11:24AM >>>
List,
i have a 1.2GB dmp file which i want to imp into my new instance (8i)=20 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
=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 - 05:52:44 CDT