Oracle compress implementation

797476

Hello
does anyone try the following compression solution based on Oracle standard compression
1) partitioning of the table which must be compressed
2) The partition are based on the month (m)
3) creating a new tablespace with compress option turn on
4) at (m +1), move partition (m) to the compressed tablespace
5) Delete Partition (m) from its original tablespace

regarads

damorgan

You can compress or not compress at the partition level. I am unclear as to the point of your inquiry.