create table test_part

(

ID NUMBER(20) not null,

REMARK VARCHAR2(1000),

create_time DATE

) compress

PARTITION BY RANGE (CREATE_TIME) INTERVAL (numtoyminterval(1, 'year'))

(partition part_t01 values less than(to_date('2018-11-01', 'yyyy-mm-dd')));


insert into test_part values (1,'a',sysdate)
insert into test_part values(2,'b',to_date('2021/7/10 5:39:24','yyyy-mm-dd hh24:mi:ss'))


select table_name, partition_name, compression from dba_tab_partitions where lower(table_name)='test_part';