var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sequence in sqlldr
I wanna load some datas from a csv file to database table.
so here is my code
APPEND INTO TABLE SCOTT.T_ROWS
FIELDS TERMINATED BY ","
(CR_CODE,ROW_CODE,DESCRIPTION,SEQ_ID SEQUENCE(MAX, 1))
im here my error is
ORA-00001: unique constraint (APEXMASTER.SYS_C0038835) violated
i know thiz is bcoz of sequence.but i dont wanna delete the existing datas in my table ,.
CAn i set the sequence to be starting from some number in thiz code???
any help ??
Plz. read the following
Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see this message
if a duplicate entry exists at a different level.
Action: Either remove the unique restriction or do not insert the key.
i wanted to know that is there any other way to give sequence value in sqlldr.
i meant can i set a starting number to the sequence in sqlldr.
tanx sharan .
tat waz helpful
how u got solution. for that! if u got means post ur solution in the forums ok.
Hey am not sharan! ok. Saravanan.R