| Partition Maintenance [message #406539] |
Thu, 04 June 2009 08:53  |
bella13
Messages: 90
Registered: July 2005
|
Member |
|
|
I have a table, each day has 5 million rows. At any given day i need to retain only prior 7days of
data. The data volume is huge to purge with a delete. So i intend to drop partitions / truncate
partitions that do not fall in the prior 7 day bucket.
Today being June 4th; i have to retain prior 7 days ; that is data from May 28 onwards.
If date was June 5th i have to retain prior 7 days ; that is data from May 29 onwards.And so on..
Since the partition key changes; how can i define this kind of partition?
Hope you can help, thanks
B>>
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
