Re: sqlldr - errors loading data

From: Ban Spam <ban-spam_at_operamail.com>
Date: Wed, 03 Oct 2001 00:59:19 GMT
Message-ID: <Xns912EB6FCAFDFFSunnySD@24.0.3.73>

farrellyr_at_yourfuture.ab.ca (Rob F.) wrote in news:25f83890.0110021159.72ae7550_at_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'.
>

I'm not sure if this has anything to do with your situation, but a short while ago I discovered that using CTAS does NOT result in the new table having any DEFAULT values that may have been in place on the original table. I suspect that a NOT NULL constraint with a default value could produce the symptom you report.

HTH & YMMV! Received on Tue Oct 02 2001 - 19:59:19 CDT