Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Indexed Tablespace Fragmentation
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,
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 - 08:19:09 CDT