Home -> Usenet -> comp.databases.oracle -> SQL*loader problem with SEQUENCE

SQL*loader problem with SEQUENCE

From: Andy Hardy <AndyHard_at_istel-is.demon.co.uk>
Date: 1995/11/04
Message-ID: <515310448wnr_at_istel-is.demon.co.uk>#1/1 






Hi,



I'm using SQLLOAD to append a large table. The key (UNIQUE INDEX) to this 
table is generated using the SEQUENCE(COUNT) command in the ctl.



However, on completion of a load I am getting 'Index in Direct Load 
State' messages because of a constraint violation - and if I check I 
can find a duplicate key.



As SQL*load is generating the number for me, why is it creating 
duplicates?



Andy

-- 
Andy Hardy


Received on Sat Nov 04 1995 - 00:00:00 CET












Original text of this message