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

Home -> Community -> Usenet -> c.d.o.server -> Re: Sql Loader: Load data in mutiple tables

Re: Sql Loader: Load data in mutiple tables

From: Volker Hetzer <firstname.lastname_at_ieee.org>
Date: Wed, 17 May 2006 16:17:17 +0200
Message-ID: <e4fb9d$ujb$1@nntp.fujitsu-siemens.com>


salman schrieb:
> how can i load data from single file into multiple tables with maintain
> refrencetial integrity of tables. please help me.
>

My experience has been that if you put your data into the loader file in the correct order and have set the constraints to defer initially deferred, it has been working so far.

Lots of Greetings!
Volker

-- 
For email replies, please substitute the obvious.
Received on Wed May 17 2006 - 09:17:17 CDT

Original text of this message

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