ORA-01502 index in unusable state

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!