Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Resize TableSpace (Index)
sorry, i realize my syntax below is missing the tablespace keyword on the
alter index commands..
should have been 'alter index xxx rebuild TABLESPACE TEMP;' etc...
"Luis Correia" <llcorreia_at_yahoo.com> wrote in message
news:m9qdnbkkv6LFIULfRVn-1g_at_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:21:15 CDT