Re: Alter index rebuild script

Hi Francis:

I not sure the ALTER INDEX ... REBUILD command renames an index (it may do it in some internal manner, but I'm not sure you can see it.) ALTER INDEX...REBUILD let's you
1) "Re-org" the index without dropping/recreating it. 2) "Move" the index to a different tablespace with different INITIAL, NEXT, etc. storage parameters.

This DDL statement rebuilds an index by reading from the old index rather than reading from the associated table, thus it's much faster. Also, if you need to move the index for a PK to a different tablespace, it does this without you having to drop the PK (and any FK's that reference the PK).

Example:

ALTER INDEX index_name REBUILD TABLESPACE new_tablespace_name;

Check the Oracle Administrator's Guide for more detailed information.

Good luck,
Dave Sisk

FRANCIS.ANSAH_at_ntc.nokia.com wrote in article <883398228.144834568_at_dejanews.com>...
> Hi,
> Please, could anyone help me with the alter index rebuild command.
>
> 1) I would like to know how it renames the old index and what happens
> if the index is dropped?
>
> 2) A script to demostrate how the rebuild index grows.
>
>
> Help for the beginner is ignorant. Thanks
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>
Received on Tue Dec 30 1997 - 00:00:00 CST