Re: Partition by day of week.

  • From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Dec 2004 23:32:43 +0100

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

Other related posts: