Re: Oracle Partitioning - 600GB Table

From: Timur Akhmadeev <timur.akhmadeev_at_gmail.com>
Date: Fri, 12 Dec 2014 21:04:19 +0300
Message-ID: <CACGsLCLS85r-EvRoMg7y5MaMhetuFhgUABCaa4SNFpFiKzkgZQ_at_mail.gmail.com>



What about exchange partition with table and subsequent partition splits?

On Wednesday, December 10, 2014, Sameer Choudhari < sameer.choudhari_at_gmail.com> wrote:

> Hello Oracle-L
>
> Oracle DB : 10.2.0.4
> OS : IBM AIX
> DB SIZE : 5TB
> Table Size : 600GB
> Application : Baking System - OLTP. Busy system.
>
> I have to RANGE partition on date field. Looking at the size of the table,
> I am confused which method to follow. In the past I have performed
> using DBMS_REDEFINITION and IMP-EXP feature for small tables i.e. <50GB.
> This time, I am worried by looking at the size of the table. Could you
> please suggest better or reliable way partitioning with minimum downtime or
> no downtime.?
>
> Cheers,
> Sameer <http://www.choudhari.net>
>

-- 
Regards
Timur Akhmadeev

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 12 2014 - 19:04:19 CET

Original text of this message