ORA-01502 index in unusable state

[agichen]

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!

[tony]

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

[Agi]

In article <388573C6...@littlebushsys.demon.co.uk>,

tony <to...@littlebushsys.demon.co.uk> wrote:
> This normally happens when you have bitmap indexes, simply do an
alter index
> '<NAME>' REBUILD;

tony,
there're no bitmap indexe on the table.(only 2 normal index)

??

Agi

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

Sent via Deja.com http://www.deja.com/
Before you buy.

[tony]

did you try the rebuild ??

[MohammedB]

Agi,

If you use sqlldr with the direct load option, your indexes will be
left in an unusable state. Do what the previous poster suggested.
Just rebuild the index.

hth

mkb

In article <38a139f2...@usw-ex0102-013.remarq.com>, agichen