title: Syntax for partition with subpartition
body: <pre><code>col1 ....
  col2 ....
  col3 ....
  col4 ....
  PARTITION BY RANGE(DATE_KEY)
  SUBPARTITION BY LIST(REGION_KEY)
  SUBPARTITION TEMPLATE
    (SUBPARTITION A VALUES (1) TABLESPACE X,
     SUBPARTITION B VALUES(3) TABLESPACE X,
     SUBPARTITION C VALUES (8) TABLESPACE X)
  (PARTITION MON_JAN_2012 VALUES LESS THAN (1000)
      TABLESPACE X
      PCTFREE 10
      INITRANS 1
      MAXTRANS 255
      NOLOGGING
    (SUBPARTITION A VALUES (1) TABLESPACE X,
     SUBPARTITION B VALUES(3) TABLESPACE X,
     SUBPARTITION C VALUES (8) TABLESPACE X),
   PARTITION MON_FEB_2012 VALUES LESS THAN (2000)
      TABLESPACE X        PCTFREE 10
      INITRANS 1
      MAXTRANS 255
      NOLOGGING
    (SUBPARTITION A VALUES (1) TABLESPACE X,
     SUBPARTITION B VALUES(3) TABLESPACE X,
     SUBPARTITION C VALUES (8) TABLESPACE X)
  </code></pre>
  
  <p>My table structure is something like this, I m new to partitions, need to add new partitions for table from March_2021 for few months, need correct syntax for this, I tried to google but not able to find example for adding partition with subpartition. Database 10g</p>