Re: Index / Extents Question

You can run a script that will rebuild the indexes eg

sql> alter index index_name rebuild;

or you can also add storage and tablespace location eg

sql> alter index index_name rebuild storage (initial 1m next 1m pctincrease 0) tablespace my_tablespace_name;

If you have a lot of indexes you could create a script like this

sql> set head off
sql> set pages 0
sql> select 'alter index '||index_name||' rebuild;' from user_indexes;

check the output looks okay (it doesn't do anything yet) and if your happy output to a file eg

sql> spool c:\myfile.sql
sql> /
sql> spool off

then run the script

sql> @c:\myfile.sql

and your indexes will be rebuilt.

Alistair

"David Williams" <david484_at_hotmail.com> wrote in message news:a7982e4d683730d65227ee3d4631f8ff.36554_at_mygate.mailgate.org...
> If I rebuild the database indexes, will that eliminate the index table
> extents? Is there a simple way or tool that I can use to remove the
> database extents? I have tried using the Data Manager utility that ships
> with Oracle Enterprise and it seems to be working on tables, but it does
> not appear to work with indexes. Can any body out there help walk me
> through these issues?
>
> Thank you,
>
> David Williams
>
>
> --
> Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Jan 22 2002 - 03:52:06 CST