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

Home -> Community -> Usenet -> c.d.o.misc -> drop of partition with clause

drop of partition with clause

From: nh <nhourdou_at_amadeus.net>
Date: 27 Mar 2003 07:58:15 -0800
Message-ID: <747d5f3b.0303270758.7f6fe11e@posting.google.com>


Hi there!
I have a partitionned table by date:

> create table T (d date, i integer) partition by range(d) (partition pi
values less than (to_date('01012003','ddmmyyyy')));

Each partition is huge (about 100.000 lines) and concerns a particular day.

Then I store data for 370 days.

So each day I add a partition and drop a 370 days old one...

I wish to know if there is a way to drop several partitions with query like:
>alter table T drop partition pi where d < aDate;

Indeed if I drop only the 370 days old partition (and not 370 and more years old partition), if one day I do not execute this query the partition will still exist...

e.g:

T:

d           i
01012001    20             partition p01012001
02012001    29             partition p02012001
03012001    30             partition p03012001

I wish to delete both p01012001 and p02012001...

In real case I do not know which partition exists before date d...

Many thanks... Received on Thu Mar 27 2003 - 09:58:15 CST

Original text of this message

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