SQL*Loader Multiple Table Loads

From: <tomwhitehill_at_my-dejanews.com>
Date: Thu, 03 Sep 1998 18:47:30 GMT
Message-ID: <6smo82$3m3$1_at_nnrp1.dejanews.com>



Hi,

[Quoted] I'd like to load data for 2 related tables with SQL*Loader. A row in Table 1 [Quoted] has a 1 to many relationship with rows from table 2. Consider a row in table [Quoted] 1 the parent of 1 the child, table 2. I can't have table 1 loaded before table 2 is loaded because it might get processed by our server before which would then cause 'orphaning' of table 2 rows. Follow me?

Does anyone know how to do this?

Thanks in advance for any help,

Tom Whitehill

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Sep 03 1998 - 20:47:30 CEST

Original text of this message