Sql*Loader multiple tables

From: <tomwhitehill_at_my-dejanews.com>
Date: Thu, 03 Sep 1998 18:45:12 GMT
Message-ID: <6smo3p$3je$1_at_nnrp1.dejanews.com>



Hi,

I'd like to load data for 2 related tables with SQL*Loader. A row in Table 1 has a 1 to many relationship with rows from table 2. Consider a row in table 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:45:12 CEST

Original text of this message