create table test_subpartition
( type_id    integer
, event_date timestamp(6) with local time zone
, value      number
) partition by list (type_id)
  subpartition by range (event_date)
(
  partition p1 values (1)
  ( subpartition p1_past    values less than (timestamp'2000-01-01 00:00:00.000000000+00:00')
  , subpartition p1_01      values less than (timestamp'2001-01-01 00:00:00.000000000+00:00')
  , subpartition p1_02      values less than (timestamp'2002-01-01 00:00:00.000000000+00:00')
  ),
  partition p2 values (2)
  ( subpartition p2_past    values less than (timestamp'2000-01-01 00:00:00.000000000+00:00')
  , subpartition p2_01      values less than (timestamp'2001-01-01 00:00:00.000000000+00:00')
  , subpartition p2_02      values less than (timestamp'2002-01-01 00:00:00.000000000+00:00')
  )
);