Hi
I am using sql loader to load a file which contains 929827 rows, This file can be loaded multiple times in the table, so I need a unique number as primary key, In my control file I have ID SEQUENCE(MAX,1) .
When I load the file once, it works fine and generate the ids from 1 to 929827, when I load the same file second time it generate the ids from 929827 to 1859654. So I have two records with Id 929827, Is there any way to solve this problem.
Farhan