Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlldr - errors loading data
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
![]() |
![]() |