Compress table.
Do you have a syntax for compress partition table which include sub partition? if you can provide an explanation that would be perfect.
Also the other question, if I compress table in 11g, how do I reclaim the space that is freed.
Thanks