Oracle Partitioning - 600GB Table

From: Sameer Choudhari <sameer.choudhari_at_gmail.com>
Date: Wed, 10 Dec 2014 19:10:31 +1000
Message-ID: <CAL4wsdD2ko0CQvBcaG3yhgka+aev8hcMi-t6A92G-+mKnBMzaA_at_mail.gmail.com>



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 - 10:10:31 CET

Original text of this message