title: How to add Subpartition for existing table in Oracle
body: <p>I wanted to add subpartition for '<code>US</code>' market in <code>SUBPARTITION TEMPLATE</code> for exisitng <code>INT_TMP</code> table. So the subpartition should be like: <code>SUBPARTITION "SP_US" VALUES ( 'US' )</code> in <code>SUBPARTITION TEMPLATE</code> for exisitng <code>INT_TMP</code> table.</p>
  
  <p>Below is my Create table statment:</p>
  
  <pre><code>CREATE TABLE INT_TMP
     (LOAD_ID NUMBER 
  , SYS_DB_NAME VARCHAR2(50 BYTE) 
  , ENTITY_ID NUMBER 
  , CHK_DATE DATE 
  , VALUE NUMBER 
  , NBR_CHECK VARCHAR2(50 BYTE) 
  , SOURCE VARCHAR2(50 BYTE),
    MONTH_ID NUMBER
     ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
   NOCOMPRESS 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE "DATA_INT_TCA_EDW" 
    PARTITION BY LIST ("MONTH_ID") 
    SUBPARTITION BY LIST ("SYS_DB_NAME") 
    SUBPARTITION TEMPLATE ( 
      SUBPARTITION "SP_SO" VALUES ( 'SO' ), 
      SUBPARTITION "SP_UK" VALUES ( 'UK' ), 
      SUBPARTITION "SP_OTHERS" VALUES ( DEFAULT ) ) 
   ( 
   PARTITION P_201801  VALUES (201801) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW , 
   PARTITION P_201802  VALUES (201802) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW , 
   PARTITION P_201803  VALUES (201803) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW , 
   PARTITION P_201804  VALUES (201804) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW , 
   PARTITION P_201805  VALUES (201805) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW , 
   PARTITION P_201806  VALUES (201806) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
    STORAGE(
    BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
    TABLESPACE DATA_INT_TCA_EDW ) ;
  </code></pre>