Re: Is there a way to load records rejected by SQL Loader in a table ?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 18 Oct 2004 08:15:13 -0700
Message-ID: <1098112465.941869_at_yasure>


Gauri Telang wrote:
> Hi,
>
> I am trying get information about the records rejected by SQL Loader,
> while loading my data file in tables.
>
> I want to load the records rejected / discarded by the SQL loader
> in a table, preferably with the information about
> the Oracle Error that caused the record to be rejected.
>
> Is there a way to do so ?
>
> Thanks in advance,
> Gauri

Aparently looking up the syntax for SQL*Loader is too much work for you .... so my only help is going to be referring you to: http://www.psoug.org
click on Morgan's Library
click on SQL Loader

Thereafter you will just have to read. Sorry. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Mon Oct 18 2004 - 17:15:13 CEST

Original text of this message