OraFighter wrote:You dont want to use constraints..
constraints makes data loading horrible ....
we are loading it as DIRECT=TRUE and PARALLEL=TRUE
OraFighter wrote:You should use an external table and have SQL remove the duplicates. Doing it through scripts etc. against the CSV is not the most ideal way to do it.
Cool down ....!! :)
I am trying to write any script as you said to remove it directly from csv file..
remember my total file size is 300gb to a single table.