Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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..."Received on Fri Apr 26 2002 - 15:04:36 CDT