Re: Oracle Partitioning - 600GB Table

From: Stefan Koehler <contact_at_soocs.de>
Date: Wed, 10 Dec 2014 11:33:20 +0100 (CET)
Message-ID: <516523876.229496.1418207600738.open-xchange_at_app02.ox.hosteurope.de>

Hi Sameer,
you can "transform" a non-partitioned table into a partitioned table with DBMS_REDEFINITION as well. You can also resync the interim table with the original table before finishing the redefinition process (keep the locks at a minimum at the end), if it is such a large one with a lot of DML activity.

Best Regards
Stefan Koehler

Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Sameer Choudhari <sameer.choudhari_at_gmail.com> hat am 10. Dezember 2014 um 10:10 geschrieben:
>
> 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>
>

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

Received on Wed Dec 10 2014 - 11:33:20 CET