Re: ORA-01502 index in unusable state

From: Agi <agichen_at_my-deja.com>
Date: Wed, 19 Jan 2000 11:02:02 GMT
Message-ID: <8645j5$sap$1@nnrp1.deja.com>

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 - 05:02:02 CST