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
compress for all operations -----------------Oracle Advanced Compression--------------
But we want some thing like below through Oracle ILM