Recent content by 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...

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...