Hi, if there are queries using between on partition key the range partitioning is more suitable; with list partitioning you are forced to use IN lists. You may also consider exchange partition to perform refresh instead of truncating the oldest partition (and inserting new data). regards, Jaromir D.B.Nemec http://www.db-nemec.com ----- Original Message ----- From: "David Sharples" <davidsharples@xxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Monday, December 06, 2004 9:06 PM Subject: Re: Partition by day of week. we had a day_no column in the table, from 1 - 8, we ranged partitioned on that column and truncated it as needed - was fine for us On Mon, 6 Dec 2004 14:10:54 -0500, rishi.jain@xxxxxxxxxxxxxxxxxxx <rishi.jain@xxxxxxxxxxxxxxxxxxx> wrote: > > Hi All, > > I need to partition a table by day of week. We need to keep 7 days worth of > data and then we can truncate the oldest partition and start over again. > has someone done so earlier ? What would be a better idea [Range or List ??] > > If someone has an example that would be great . > > Rgds > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l