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: Rob F. <farrellyr_at_yourfuture.ab.ca>
Date: 2 Oct 2001 12:59:24 -0700
Message-ID: <25f83890.0110021159.72ae7550@posting.google.com>


Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<u3d52tqxf.fsf_at_verizon.net>...
> On 1 Oct 2001, farrellyr_at_yourfuture.ab.ca wrote:
>
> > The data file looks to have values for each column.
>
> Check again.

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'. Received on Tue Oct 02 2001 - 14:59:24 CDT

Original text of this message

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