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.

alter index xxx rebuild online;

although you probably want to see if you really need to reorg...

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."