Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*Loader

Re: SQL*Loader

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 23 Mar 2000 19:42:34 +0100
Message-ID: <953837814.8745.1.pluto.d4ee154e@news.demon.nl>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US