Database Administration (MOSC)

MOSC Banner

Do ADO policies do compression again?

edited Mar 6, 2023 10:39AM in Database Administration (MOSC) 2 commentsQuestion
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center