Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader
Write a sql-loader control file including the bad option (which will make
sure all bad records endup in s a separate file), write a .cmd file and
submit that using the NT at command and you should be set.
Hth,
Sybrand Bakker, Oracle DBA
Rekha <your_at_attcanada.net> wrote in message
news:YwtC4.13596$Ge1.292617_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 - 12:42:34 CST