I think that some reading of documentation is called for.

You can "ALTER TABLE ... COMPRESS" to enable compression for new data, or "ALTER TABLE ... MOVE COMPRESS" to compress data already in the table.

PANDO, I think you were a little premature in closing ksridhar's thread, eh?