Partition Table by week
mantovamJan 24 2012 — edited Jan 25 2012Hi folks
I need do a partition in a table. This table have a column in date format that I can use to partition.
The goal is:
Partition by week of year
Retention of 60 days
I can not create a new column in table ( and maybe use partition by list )
I can not create invisible column. The database is 10G R2.
How to do this ?
Create 52~53 partitions that are the total of week in a year ?
Have a way more easy to control or to do this?
Tkanks