Direct path loader

[koningh]

I use direct path loading to store around 80.000 records in a huge table (>30.000.000 records). After executing and finishing the direct path loading I got on one or more of the 4 indexes the following error: ORA-01502: index ...... or partition of such index is in unusable state. After rebuilding the indexes everything is fine. Using consecutive inserts this problem does not occur.

Do you have any clue what the problem is?

 

[Marco Kalter]

According to the error message, the index was created while the load was taking place. I don't assume this is the case here?

------------------
Marco Kalter
Allround Automations

 

[koningh]

You are right assuming this is not the case. At the moment of loading the data nobody was using that particular table. However I got the following hint from one of our DBA's. After finishing direct loading he assumes that Oracle uses "alter index rebuild" to update the index. If something goes wrong there (e.g. not enough temp space for rebuilding the index) no specific indexing error is reported and the index is left in the mentioned inproper state. Can this be the case?

 

[Marco Kalter]

I'm not sure. I would have to look into that.

------------------
Marco Kalter
Allround Automations