Re: SQL*Loader REALLY unique sequences

To get a unique sequence on each load you can also use

 colname SEQUENCE (startnum,increment) ! where startnum is spec'd by you

 colname SEQUENCE (MAX,increment) ! where (if I remember right) MAX is the


                                  ! largest value for the col currently in

                                  ! the table and loader will start #'ing 


                                  ! w/MAX+increment



-- 
Joel Fedorko                         Remember Bit Hopper, 
Consultant                     You must become one with the machine.
Day Data 
jfedorko_at_ncsa.uiuc.edu        Any opinions I express will be ignored.