Partition by day of week.

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