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?
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-lReceived on Fri Dec 12 2014 - 19:04:19 CET