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

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr - errors loading data

Re: sqlldr - errors loading data

From: Bliss <bliss_is_ignorance_at_hotmail.com>
Date: Fri, 26 Oct 2001 00:22:20 +0800
Message-ID: <3bd83c30_1@news.tm.net.my>


Check the .LOG file and the .BAD file for errors and rejected records respectively.. It'll tell you which record is rejected and why....

"John Strange" <jstrange_at_imtn.dsccc.com> wrote in message news:3bd8032f$1_at_news.alcatel.com...
>
>
> Maybe table 2 is missing a database trigger that table 1 has.
>
>
> : Galen Boyer <galenboyer_at_hotpop.com> wrote in message
news:<u3d52tqxf.fsf_at_verizon.net>...
>
> : My problem is that the data loads into one table (original) and not
> : the other (copy). Same datafile same control file. I receive an
> : error about inserting a null value. How can I tell which column is
> : rejecting the record? Also why would I be able to insert into one
> : table and not the other. I created the copy as 'select * from
> : original_table'.
>
> --
> While Alcatel may claim ownership of all my ideas (on or off the job),
> Alcatel does not claim any responsibility for them. Warranty expired when
u
> opened this article and I will not be responsible for its contents or use.
Received on Thu Oct 25 2001 - 11:22:20 CDT

Original text of this message

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