Re: SQL*Loader

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.

Daniel
Austin, TX

Rekha <your_at_attcanada.net> wrote in message news:QstC4.13594$Ge1.292707_at_newscontent-01.sprint.ca...
> Hi
>
> 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
>
>
>
Received on Thu Mar 23 2000 - 00:00:00 CST