Option ILM POLICY
Help, please, I compare tables but do not see ILM POLICY.
The ILM POLICY option is enabled.
Script:
CREATE TABLE salesado
(PRODID NUMBER NOT NULL,
CUSTID NUMBER NOT NULL,
TIMEID DATE NOT NULL,
CHANNELID NUMBER NOT NULL,
PROMOID NUMBER NOT NULL,
QUANTITYSOLD NUMBER(10,2) NOT NULL,
AMOUNTSOLD NUMBER(10,2) NOT NULL)
PARTITION BY RANGE (timeid)
( PARTITION salesq12012 VALUES LESS THAN (TODATE('01-APR-2012','dd-MON-yyyy')),
PARTITION salesq22012 VALUES LESS THAN (TODATE('01-JUL-2012','dd-MON-yyyy')),
PARTITION salesq32012 VALUES LESS THAN (TODATE('01-OCT-2012','dd-MON-yyyy')),
PARTITION salesq42012 VALUES LESS THAN (TO_DATE('01-JAN-2013','dd-MON-yyyy'))
);
ALTER TABLE salesado MODIFY PARTITION salesq1_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED ROW
AFTER 30 DAYS OF NO MODIFICATION;
COMMIT;
ALTER TABLE salesado MODIFY PARTITION salesq2_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED SEGMENT
AFTER 3 MONTHS OF NO MODIFICATION;
COMMIT;
ALTER TABLE salesado MODIFY PARTITION salesq3_2012
ILM ADD POLICY ROW STORE COMPRESS ADVANCED GROUP
AFTER 6 MONTHS OF NO MODIFICATION;
COMMIT;