ORA-26028: index initially in unusable state
Posted: Wed Jan 19, 2005 2:12 am
Hi All,
just wondering if anyone has ever seen this message before. I haven't.
Situation is we are loading a couple of years worth of history for a transaction file. We have split the work into pieces because daily updates will be incremental so we only allocated the disk for incremental updates and didn't allocate disk to run a one off load of 2 years history. (No real need for it)
I have a job to gunzip each file in turn and then load it. The first gunzip->load->gzip worked fine but for some reason left an index on the table in an unusable state. Easy to fix, drop/re-create the index. But we lost 14 hours elapsed processing time overnight and I'd prefer not to lose it again tonight...
Does anyone know where I might look to find out what might have happened? Like why did the index become unusable and was it anything I did? Is there a detailed Oracle log somewhere that might tell me? (I know this is possibly the wrong place to ask but I thought someone here might have seen this problem specifically....)
Thanks
mtl_unit_transactions_06a..Oracle_OCI_Load_141: Internal Error: Unable to initialize the Direct Path Context
ORA-26028: index ORAPRDSTAGE.MTL_UNIT_TRANSACTIONS_IX1 initially in unusable state
just wondering if anyone has ever seen this message before. I haven't.
Situation is we are loading a couple of years worth of history for a transaction file. We have split the work into pieces because daily updates will be incremental so we only allocated the disk for incremental updates and didn't allocate disk to run a one off load of 2 years history. (No real need for it)
I have a job to gunzip each file in turn and then load it. The first gunzip->load->gzip worked fine but for some reason left an index on the table in an unusable state. Easy to fix, drop/re-create the index. But we lost 14 hours elapsed processing time overnight and I'd prefer not to lose it again tonight...
Does anyone know where I might look to find out what might have happened? Like why did the index become unusable and was it anything I did? Is there a detailed Oracle log somewhere that might tell me? (I know this is possibly the wrong place to ask but I thought someone here might have seen this problem specifically....)
Thanks
mtl_unit_transactions_06a..Oracle_OCI_Load_141: Internal Error: Unable to initialize the Direct Path Context
ORA-26028: index ORAPRDSTAGE.MTL_UNIT_TRANSACTIONS_IX1 initially in unusable state