We have been trying to solve a problem with using the direct loader in the oracle enterprise stage for awhile now. I've already done alot of searching on the forum to try and solve this myself but with no luck.
The table we are trying to load is partitioned and has a number of bitmap indexes applied. All of the indexes are local range partitioned except the primary key which defaults to a global index.
So far, I've managed to get data to be loaded into the Database using "Disable Constraints = true" and "Index mode = Maintenance" but this has caused errors when trying to re-enable the constraints:
Code: Select all
orclDetailFact: Oracle call failed; sqlcode = -604; message: ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'CBA_DBA.I1_DETAIL_FACT' or partition of such index is in unusable state
orclDetailFact: ExecuteImmediate failed for:
alter table DBA.RPT_DETAIL_FACT enable constraint FK_DETAIL_FACT_1.
Code: Select all
orclDetailFact: All indexes on table `RPT_DETAIL_FACT' are not local range partitioned indexes;
therefore, the -index maintenance option cannot be used.
Can I also assume that I'm getting the "unusable state" error with "Disable Constraints = true" because DS is assumeing that we are using local indexes? I've also used upsert instead of load to confirm that our data does not contain any errors which break constraints.
Please help! I'm out of ideas of how to fix this.