I want to load records into table from a file.
I want to find out the duplicate records in a table where in i have defined primary key.
now while loading the data into table it will reject duplicate records because of the constraint and
put all those duplicate recrods in .dsc file...
but if i use BULK Load option in SQL*Loader.. as i understand it will first disable table constraints and then load data..
because of this i cannot find out the duplcate rows...
i have tried out that using BULK load option performance is more than 60% higher than conventional loading method using SQL*Loader ..
now any body can please help me out finding duplicate rows with same performance what i am getting with bulk load??
it is very urgent..
thanks in advance