Re: Indexed Tablespace Fragmentation

Why reorg?
If you really need to do this just
alter index y rebuild tablespace x;
x bing the tablespace it is in.

Jim

"Mike Borden" <tilwenbr_at_netscape.net> wrote in message news:8a41a7df.0204260519.4460c89e_at_posting.google.com...
> 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.
Received on Fri Apr 26 2002 - 09:24:41 CDT