Re: Unusable index

If you move a table... alter table <xxx> move tablespace <tbs2>, all indexes on that table will be marked as invalid because the rowids associated with the keys are now incorrect. Just rebuild the index, and it will be usable again.

Dennis

prasad maganti wrote:

> Hi dba's
>
> can anybody clarify what is unusable index, in what
> situation will become unusable?
>
> and the solution to reuse it?
>
> thanx in adva.
>
> prasad.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dennis M. Heisler
  INET: dheisler_at_binghamton.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).