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
Oracle - data loading issues
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers