Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how to IMP lookup tables first, and referencing tables later ?

how to IMP lookup tables first, and referencing tables later ?

From: Rahul <rahul_at_ratelindo.co.id>
Date: Tue, 18 Jul 2000 15:12:18 +0700
Message-Id: <10562.112240@fatcity.com> 





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
Received on Tue Jul 18 2000 - 03:12:18 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US