I am using the sqlldr to load data with options direct=true and parellel=true.
now my question is i have some column with unique indexes .
if at all any record is duplicate then index becomes unusable.
so what is the solution to delete those records which are violating unique indexes.
2) can any one provide me the query with the use of hints which does not make use of the
index which is in un usable state and delete the records.