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,
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