Best approach to implement Oracle Advance Compression on existing tables
We are planing to implement Oracle Advance Compression on many existing databases to reduce the space consumption. I performed some testing coping tables to an New tablespace with COMPRESS option OLTP and it reduce 50% off the space utilization.
Which is the best approach to implement Advance Compression on existing tables?