Row-level compression policies for ADO operate only on database blocks in which all the rows qualify based on the policy condition for compression. You can specify compression at the row level within a table using a row-level compression tiering policy. With row-level compression in combination with segment level compression tiering policy, you have fine-grained control over how the data in your database is stored and managed
The following SQL statement in Example 5-7 creates a policy that compresses the rows of the table sales_ado for OLTP after 30 days without modification of the data:
Example 5-7 Using row-level compression tiering
ALTER TABLE sales_ado ILM ADD POLICY ROW STORE COMPRESS ADVANCED ROW AFTER 30 DAYS OF NO MODIFICATION; SELECT SUBSTR(policy_name,1,24) POLICY_NAME, policy_type, enabled FROM USER_ILMPOLICIES; POLICY_NAME POLICY_TYPE ENABLE ------------------------ ------------- ------- ... P8 DATA MOVEMENT YES