Question:

I need to implement automation of loading Data from non-oracle(like excel,
access)  resources into Oracle 8 using sql*loader, about 2 million records
every morning, there will be some bad data which would have to be refined
 at an estimate abt 5000 rows out of 2million).

Can someone kindly give me ideas how to go for it using sql*loader or any
3rd party tool, it has to be automated, as manually loading 2 million
records every morning will be very time consuming.

Tks for your help
Rekha

Answer 1:

I use a work table with a trigger to normalize the data.  The end result is
an error table to tell me which row failed and why and a table of the failed
records... speed is good and I haven't had any problems with reliability.  I
just truncate the work table and start the import.

Answer 2:

Just have cron run sqlldr every morning.  There are several example
sqlldr control files in the Oracle documentation.  You'll probably
want to export the Excel or Accesss information to a CSV text file.