Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Resize TableSpace (Index)

Re: Resize TableSpace (Index)

From: Luis Correia <llcorreia_at_yahoo.com>
Date: Thu, 21 Jul 2005 11:21:15 -0400
Message-ID: <ouGdnZwC8rv7IELfRVn-uA@rogers.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US