Oracle Partitioning - 600GB Table
- From: Sameer Choudhari <sameer.choudhari@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 10 Dec 2014 19:10:31 +1000
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>
Other related posts:
