DSXchange

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

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.