2 Replies Latest reply on Mar 20, 2015 4:39 PM by 12cdb

    Basic Compression

    Paul Vidal

      Hello Everyone.

       

       

      I'm planning to apply compression for a readable only database.

      But the customer does not want to pay for advance compression.

      The customer wants to archive data on a yearly basis for some history tables and with the basic compression I can do it pretty well.

       

      The question will be :

      Do the customer need to pay for basic compression ?

       

      like this for example :    create table mytable compress as select * from my_other_table;  -- I know that I need to rebuild the indexes every time  insert data into that compressed table but that should be fine for me since is once a year.

      or for using it in Datapump export/import.

       

      Thanks in advance.