Re: Bitmapped Indexes, Anyone?

Paul D Miller <pmiller_at_mv.mv.com> wrote:
>I've been experimenting with them on our system. A few times I've gotten
>ORA-01502 which says that the index is in direct load state--drop the
>index and recreate.
>This is supposedly caused by using the direct load option of SQL*Loader,
>but we're not. Are the indexes getting corrupted?
>Has anyone else seen this problem?

Yes I have! The problem has to do with the Primary Key. I have created some BITMAP Indexes and then enabled the PK. Immediately they go into direct load state.

The answer is to recreate the BITMAPs after messing with a PK.

• Doug Anderson Oracle Database Administrator DAtheDBA_at_mindspring.com