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>
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