Re: ORA-01502 index in unusable state

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

agichen wrote:

> Hello, everyone,
> When I run some procedure,I got
> "ORA-01502: index xxx or partition of such index is in unusable state
>
> Why ?? What should I do ??
>
> I use sqlldr to load( load truncate) some data to table A,will this
> caused the index is in unusable state ??
> Must I rebuild the index after I truncate the table every time ??
>
> Thanks for any suggestions in advance !!
>
> Rgds,
> Agi
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Wed Jan 19 2000 - 02:20:22 CST