Do ADO policies do compression again?
I have a compressed table with ADO policy for 3 months of no modification, but the company management want to change to 1 month. Data already compressed and meeting new policy requirements, will it be compressed again? EX: --Old policy ALTER TABLE TAB_HR ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT AFTER 3 MONTHS OF NO MODIFICATION; --New policy after old policy has been executed ALTER TABLE TAB_HR ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT AFTER 1 MONTHS OF NO MODIFICATION;
Edited for better clarification.
Tagged:
0