Partition by day of week.

  • From: Rishi.Jain@xxxxxxxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 6 Dec 2004 14:10:54 -0500

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 .


Other related posts: