Resize TableSpace (Index)

From: Luis Correia <llcorreia_at_yahoo.com>
Date: Thu, 21 Jul 2005 11:16:45 -0400
Message-ID: <m9qdnbkkv6LFIULfRVn-1g@rogers.com>

hello..

in oracle 7.3.4, if i want to resize (down) the datafiles for a table space used for indexes
but oracle refuses because the free space is not contiguous at the end of the datafiles - can i do the following without effecting client applications (i.e. perform these actions online)?

'alter index xxx rebuild TEMP;' to rebuild all the indexes to a temporary
tablespace with enough space.
'alter tablespace index_ts coalesce'; to coalesce all free space
perform the resize of the datafiles...
'alter index xxx rebuild index_ts;' to rebuild all indexes back to their
'home' tablespace
Received on Thu Jul 21 2005 - 10:16:45 CDT