Re: Removing Partitions While Online

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 22 Dec 2005 09:55:58 +0100
Message-ID: <dodpmv$dt5$01$1@news.t-online.com>

Michael42 schrieb:
> Hello,
>
> I have a table that has 5 partitions using an integer based range. I
> would like to "un-partition" this table. In this environment it is
> very difficult to get any downtime.
>
> What options or techniques can you recommend (please elaborate)?
>
> Thanks - sincerely appreciate your advice,
>
> Michael
>

It depends on which Oracle version you are and whether you have enough space. You can do it with DBMS_REDEFINITON package ( if Oracle version allows and free space is not an issue)
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_redefi.htm#sthref5656 or merge all partitions into the last one and exchange this one with nonpartitioned table
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_3001.htm#i2132937

Best regards

Maxim Received on Thu Dec 22 2005 - 02:55:58 CST