Your best bet is to drop and rebuild the index with the storage settings
that you want. You can do this with dba_studio if you wish, which you can
download from technet.oracle.com for free for development purposes.
Good Luck!
--
~~~~~~~~~~~~~~~~
Chris Weiss
www.hpdbe.com
High Performance Database Engineering
~~~~~~~~~~~~~~~~
"David Williams" <david484_at_hotmail.com> wrote in message
news:4854ac442f365dfbfc664b9f22a1c9b9.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 Wed Jan 23 2002 - 18:40:08 CST
