Question: index are in unusable state?
Answer: SQL*Loader leaves indexes in an Index Unusable state when the data segment being loaded becomes more up-to-date than the index segments that index it. Any SQL statement that tries to use an index that is in an Index Unusable state returns an error. ... There are duplicate keys in a unique index.