Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_verizonwireless.com
<rishi.jain_at_verizonwireless.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 06 2004 - 14:15:25 CST
![]() |
![]() |