Re: Sql*Loader multiple tables

Hi Tom,

    Sorry my finger slipped and the #$%^&*_at_ program mailed the message before I finished it. Hopefully this time I will make it through to the end.

    Okay, you have two problems:

1. Loading two tables from one file.
2. Preventing some batch processes from accessing the tables prematurely

    Loading two or more tables from one file using SQL*Loader is accomplished through the use of when conditions.

    The second problem can be handled by having the table owned by a userid other than the one(s) used for the batch processes. Build a operating system shell script that does the following:

1. execute a SQL*Plus script to revoke privileges on the table(s)
2. run the SQL*Loader
3. execute a SQL*Plus script to grant privileges on the table(s)

regards

Jerry

tomwhitehill_at_my-dejanews.com wrote in message <6smo3n$3jd$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 Fri Sep 04 1998 - 00:00:00 CEST