1 Reply Latest reply: Oct 6, 2012 1:47 AM by damorgan RSS

    How to Set Basic compression attribute through Oracle ILM

    36938
      Hi,

      I have log a SR with Oracle with regard to this but they redirect to this forum.

      We have configured Oracle ILM in our environment. We have a requirement that after 3 years the data to be moved to a Low Cost Storage. We tested the same through Oracle ILM and it works fine for the above scenario.
      We have another requirement that after moved to Low Cost Storage Tier through Oracle ILM we also want to compress the data.
      When we set the compressed attribute through Oracle ILM it alwasy generated the script
      like the one below

      alter table test_user.range_part
      move partition year4
      tablespace part3
      compress for all operations -----------------Oracle Advanced Compression--------------
      update indexes;

      But we want some thing like below through Oracle ILM

      alter table test_user.range_part
      move partition year4
      tablespace part3
      compress -------------------Basic Compression----------------
      update indexes;

      Can you please help us how to set the Basic compression attribute through Oracle ILM.

      Thanks and Regards
      Ganesan Sivaraman