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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Partition by day of week.

Re: Partition by day of week.

From: David Sharples <davidsharples_at_gmail.com>
Date: Mon, 6 Dec 2004 20:06:45 +0000
Message-ID: <be592d55041206120657b371ce@mail.gmail.com>


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-l
Received on Mon Dec 06 2004 - 14:15:25 CST

Original text of this message

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