Re: Partition by day of week.
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 6 Dec 2004 20:06:45 +0000
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
Other related posts:
