Re: Unusable Index problem

This normally happens when you have bitmap indexes, simply do an alter index '<NAME>' REBUILD;

Jerome Chik wrote:

> Hi,
>
> I'm wondering what would cause an index to be unusable and how do I
> avoid this?
>
> It seems to happen after I do a data load with sql*loader using a direct
> path method. Once the data is loaded, certain indexes become unusable.
>
> Using a 8.1.5 database.
>
> Thanks,
>
> Jerome.
Received on Wed Jan 19 2000 - 02:11:33 CST