SQL Loader and multiple tables

From: Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com>
Date: Thu, 25 Mar 1999 17:00:32 -0800
Message-ID: <36FADC30.41D299D8@non-hp-usa-om46.om.hp.com>

RDBMS: 7.3.4 I am using SQL*Loader to load two tables from a single file and want to do the following:

The first record in the file is a header record - I will asign a SEQUENCE(MAX,1) value to a LOAD_ID field in table_a_header.

The remaining records will be loaded into table_a which also has a LOAD_ID field.

I want to use the LOAD_ID generated by the SEQUENCE for table_a_header for all the records that will be loaded into table_a.

I need to be able to have a relationship between the two tables, if anyone has any suggestions, I would appreciate it.

Thanks.

--
Michael A. Rothwell
Oracle DBA/Oracle Web Applications Developer

Views expressed here are not those of my company No - Actually - Since I am independent, They are the views of my company. Received on Thu Mar 25 1999 - 19:00:32 CST