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: John Strange <jstrange_at_imtn.dsccc.com>
Date: 25 Oct 2001 07:18:55 -0500
Message-ID: <3bd8032f$1@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 - 07:18:55 CDT

Original text of this message

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