A table containing some old data 2000-2009 now contains 50mill rows
I would partition this table into year partitions.
Is it possible to remove a partition (every partition with data older than 2 years).
And then when needed add the partition again ?
So the partition should be detach and attachable from a script/batch.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…