Re: sql*loader...

From: Amber Allen-Sauer <amber_at_allen-sauer.com>
Date: Thu, 30 Dec 1999 13:55:45 -0700
Message-ID: <386BC6D1.E2D5F366_at_allen-sauer.com>


Just run the ctl file twice, once against a.dat and then against b.dat. Use a shell script to feed the filenames instead of hardcoding them in then ctl file.

Amber



Allen-Sauer Consulting, Inc.
  Internet: amber_at_allen-sauer.com

            http://www.allen-sauer.com

Ratna Kumar wrote:
>
> Is there a way to load two files "a.dat" and "b.dat" into tables A and
> B RESPECTIVELY , using same control file .
> The WHEN condition was not suitable to seperate the Loading of files.
>
> Thanks,
> Ratna

--
Received on Thu Dec 30 1999 - 21:55:45 CET

Original text of this message