Keeping December partition through the year
- From: mkline1@xxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Apr 2004 15:18:10 +0000
We've got a repository that is quite large and so the data can at least be
partitioned by month. That's good.
But we've got December 2003 data they want to keep. We're now into April... We
normally only keep 3 months. What we do is truncate the oldest partition and
then load the newest. Eventually, I come along and drop the unused partitions.
Now that we are holding 200312, can I safely drop 200401, and others as time
goes along, or do I need to keep ALL of them until next December? We're using
100mb unform extents as these can go to 22gb per month, but I could always move
them to a 1M uniform tablespace once they are truncated.
At this time the 200401 partition is empty, 200312, 200402,and 200403 have
data. I'll be creating the 200404 in a couple of weeks. Before they load that,
they will truncate 200402.
It's 8.1.7.4 on HP-UX.
--
Michael Kline, Principle Consultant
Business To Business Solutions
13308 Thornridge Ct
Midlothian, VA 23112
804-744-1545
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
