Re: Oracle Partitioning - 600GB Table

From: Stefan Koehler <>
Date: Wed, 10 Dec 2014 11:33:20 +0100 (CET)
Message-ID: <>

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:
Twitter: _at_OracleSK

> Sameer Choudhari <> hat am 10. Dezember 2014 um 10:10 geschrieben:
> Hello Oracle-L
> Oracle DB :
> 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 <>

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

Original text of this message