Re: ORA-01502 index in unusable state

did you try the rebuild ??

Agi wrote:

> In article <388573C6.C1B42DA7_at_littlebushsys.demon.co.uk>,
> tony <tony_at_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.
Received on Wed Jan 19 2000 - 08:27:45 CST