Re: Rebuild Index

The reason to rebuild index is to coalesce the free space into a contiguous disk space. The
best way to do this is to set the parameter pctincrease to 1 for the tablespace in question or
for that matter all tablespaces except Oracle related tablespaces such as SYSTEM, ROLLBACKS, TOOLS etc.

If you do this SMON coalesces the free space. Some times it takes upto about 15 minutes to do it
but it does it automatically.

Try it. Have Fun !!!

suresh.bhat_at_mitchell-energy.com

Vincent Birlouez <birlouezv_at_logica.com> wrote in article <351FC799.F71F2E3F_at_logica.com>..

snip >
>
> I thank you for your help. I agree with all of what you wrote...except
with
>
> "ALTER INDEX ... REBUILD will create the new index in your default
> tablespace, using the default tablespace space parameters, unless you
> provide tablespace and space parameters when you rebuild."
>
> I issued the following statement :
> ALTER INDEX index_name REBUILD TABLESPACE tbs2;
>
> Oracle rebuilt the index in the tablespace tbs2 (a different one) with
the
> storage parameter of the index being rebuild (and so did not used the
> default storage parameter of tbs2)
>
Received on Thu Apr 09 1998 - 13:10:11 CDT