Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

Re: Keeping December partition through the year

From: Mladen Gogala <>
Date: Wed, 21 Apr 2004 11:38:49 -0400
Message-ID: <>

Nice people of the EMC corporation will gladly help you out. As we, the DBA folks, like to say, disks are cheap. The last increase in the storage capacity that my company bought in February didn't cost me a penny. It was all paid for by the company. So, as a DBA to DBA, I recommend you to adopt relaxed and aloof attitude toward disks and storage ASAP. Burn as much storage as you can. You can even ask EMC for kickbacks. Set all your datafiles to autoxtend, without specifying the maxsize. A 32GB temporary tablespace will be able to hold all of your sorts from the invention of the wheel till present, and simultaneously. Set undo retention to 24 hours to honor Kiefer Sutherland. That way, we may be able to save some precious storage at

On 04/21/2004 11:18:10 AM, wrote:
> 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.

Mladen Gogala
Oracle DBA

This message is for the named person's use only.  It may contain confidential, proprietary or legally privileged information.  No confidentiality or privilege is waived or lost by any mistransmission.  If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender.  You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
Received on Wed Apr 21 2004 - 10:37:12 CDT

Original text of this message