Hi, I need to create a table in oracle with a dayly partition, I mean that table partition should be dynamic.
My scenario requires to have last 7 days data on line; considering that one day process produces around 15 million of records, I would like to implement a mechanism that allows a fast and efficent access to current day data.
I have few questions about it:
1) is it possible to partition table data on day rolling?
2) is there something I should be aware of with this approch?
3) is there any kind of issue I have to expect while deleting "one day" data (I mean deleting data of one day - 7 (+ 1)?
Thanks in advance