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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Collapse partitions in 9i - What all options do i have?

Re: Collapse partitions in 9i - What all options do i have?

From: David Sharples <davidsharples_at_gmail.com>
Date: Sun, 22 Jul 2007 10:40:06 +0100
Message-ID: <be592d550707220240t6a6db934i4184d7d4403b2ab2@mail.gmail.com>


create table xxx as select * from yyy; drop yyy, rename xxx to yyy and rebuild your indexes - with those tiny tables it wont take any time at all

On 22/07/07, vikram singh <vikramsingh120_at_gmail.com> wrote:
>
>
> What are the various ways i have to collapse partitions in a DB?
>

--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jul 22 2007 - 04:40:06 CDT

Original text of this message

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