Re: Oracle Partitioning - 600GB Table

Dbms_redef may or may not be a good choice, it depends on the differences between the design of the old table vs the new table, as well as how much DML takes place on the table.

For very active tables, the Mview that is the foundation of dbms_redef may not be able to keep up.

To make the right choice, you need a test system of the same size, and a workload si,liar to production.

Jared

On Friday, December 12, 2014, Timur Akhmadeev <timur.akhmadeev_at_gmail.com> wrote:

> What about exchange partition with table and subsequent partition splits?
>
> On Wednesday, December 10, 2014, Sameer Choudhari <
> sameer.choudhari_at_gmail.com
> <javascript:_e(%7B%7D,'cvml','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
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Principal Consultant at Pythian
Pythian Blog http://www.pythian.com/blog/author/still/
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l