Re: ORA-01502 index in unusable state

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.003f6e7c_at_usw-ex0102-013.remarq.com>, agichen <agiNOagSPAM_at_feib.com.tw.invalid> 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 from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!