Partitioning Oracle table
Posted on 2015-01-16
I have a table and I like create partitioning and like to keep only last 10 days of data.The idea is to drop the partitioning using a script (data which is older than 10 days ).Every day the table gets around half a million of rows except saturday and sunday . The table have the timestamp column.
How can I do the partitioning of this table so that it can be manageable using partitioning and I can manage and keep only 10 days of data. Please note that the data is not required older than 7 days but I will keep for another day or 2 ( so may be 10 days at the max).