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>
Allen-Sauer Consulting, Inc.
Internet: 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
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