Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Keeping December partition through the year

RE: Keeping December partition through the year

From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
Date: Wed, 21 Apr 2004 09:30:07 -0600
Message-ID: <87E9F113CEF1D211A4C30090273018741BBCA6@ddbcinc.ddbc.local>


You can drop any partition from a partitioned table and keep any partition, so you can drop the January 04 partition when you no longer need or want that data, keeping the December 03 partition indefinitely.

Of course, if you have automated this process and the process looks for the earliest partition to drop, you will, of course, have problems. You'll need to resolve these implementation problems, but there are no database functionality problems to the situation you describe.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of mkline1_at_comcast.net Sent: Wednesday, April 21, 2004 9:18 AM
To: oracle-l_at_freelists.org
Subject: Keeping December partition through the year

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Wed Apr 21 2004 - 10:25:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US