Re: Periodic management of Oracle10g partitions!

From: David Aldridge <slimdave_at_yahoo.com>
Date: 18 Jan 2005 12:26:39 -0800
Message-ID: <1106079999.795969.229100@c13g2000cwb.googlegroups.com>

It seems that you are trying to limit yourself to these three partitions for some reason. It would make more sense to me if you had a series of monthly partitions like ...

partition by range (my_date)
(

Y2005_M01 values less than (to_date('01-feb-2005','YY-mon-YYYY')),
Y2005_M02 values less than (to_date('01-mar-2005','YY-mon-YYYY')),
Y2005_M03 values less than (to_date('01-apr-2005','YY-mon-YYYY')),
Y2005_M04 values less than (to_date('01-may-2005','YY-mon-YYYY')),
Y2005_M05 values less than (to_date('01-jun-2005','YY-mon-YYYY')),

...
)

Is there a reason why this would not be suitable? Received on Tue Jan 18 2005 - 14:26:39 CST