Oracle - data loading issues

[srini.dw]

Hi,

getting warnings at the time load data into oracle table.

issue as index unusable state. Is there any approach to override this issue.

OraWkdWorkRaw,0: ORA-39776: fatal Direct Path API error loading table WORK_ODS
OraWkdWorkRaw,0: ORA-26026: unique index SYS_C00609384 initially in unusable state
OraWkdWorkRaw,0: SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Please suggest possible ways to get rid of these warnings.

Thanks,
Srini

[chulett]

Talk to your DBA and resolve the issue that is leaving indexes in an UNUSABLE state. Typically loading duplicates into a unique index is the reason behind that. As long as they are "unusable" you won't be able to bulk load into the table.