This discussion is archived
1 Reply Latest reply: Oct 5, 2012 11:47 PM by damorgan RSS

How to Set Basic compression attribute through Oracle ILM

36938 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points