When you are inserting the data you have to use the APPEND option with the INSERT statement or DIRECT LOAD if you are using SQLLOADER otherwise your data will not be compressed.

HTH
Mike