Re: Indexed Tablespace Fragmentation

Mike Borden wrote:

> I have done a search on this and haven't found what I wanted to know.
> I want to Reorg one of my Indexed Tablespaces. It is badly framented
> with the free space. I know that you can rebuild indexes on the fly
> and even put them in a different tablespace. However, I just want to
> make sure that I can do this with no downtime at all. I plan on fixing
> this by,
>
> 1) create a "temporary" tablespace to move the indexes over to it.
> 2) drop the old index tablespace.
> 3) Recreate it with one big datafile.
> 4) rebuild the indexes and move it back over to the "new" one big
> datafile tablespace.
>
> The reason why it needs to have the original name is because this
> database is a vendor database, so we are not really supposed to mess
> with the schema. It has to stay in the same named tablespace.
>
> I'm running Oracle 8.1.7.1 aix 4.3.3. Not in an ops environment, just
> a single instance and database.
>
> I'm 95% sure I can do this during uptime. I just want to be double
> sure of this.
>
> If you know of another way please let me know.

Conver the tablespace to locally managed with uniform extents. That way you will never have to deal with it again.

Daniel Morgan Received on Fri Apr 26 2002 - 10:33:55 CDT