-- Create table
create table T_TEST1
(
t_key varchar2(20),
createtime DATE
)
partition by range (CREATETIME)
(
partition SUBDIFF1 values less than (TO_DATE(' 2017-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
);
create index T_TEST1_key on T_TEST1 (t_key)
local;