Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unused index
Hello,
when you move a table from one tablespace to another with that command, you must rebuild your indexes.
if you will not do so you will get the error:
ora-01502: index 'index_name' or partition of such index is in unusable state.
if you still want to move your table use imp/exp this is the only way to reorgenize your table.
the command for rebuilding your index is:
alter index index_name rebuild;
<rpereira_at_my-deja.com> wrote in message news:8s2aar$lho$1_at_nnrp1.deja.com...
> Hi Gurus,
>
> Is there anyone who knows why when I issue the following command to
> un-fragment a table all of it indexes are unused?
>
> alter table table_name move tablespace new_or_old_tablespace_name
> storage (initial 1M next 1M pctincrease 0)
>
> What should I do to avoid the rebuild of the indexes?
>
> Look forward hearing from you.
>
> Thanks
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Oct 11 2000 - 17:44:51 CDT