title: How to add interval partitions to an existing table in Oracle
body: <p>I have a scenarios like ,I need to create interval partitions(monthly) to an existing table in Oracle which has no partitions .please suggest me how to proceed.</p>
  
  <p>I tried with below </p>
  
  <pre><code>alter table RSST_TP_ORDERINVOICED_NETREV_F 
    set interval(NUMTOYMINTERVAL(1,'MONTH')); 
  TABLESPACE "RSST_DATA" 
    PARTITION BY RANGE ( "DATE_SK" ) 
    INTERVAL ( NUMTOYMINTERVAL(1,'MONTH') ) ( 
  PARTITION "P_FIRST" VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  TABLESPACE "RSST_DATA" ) 
  </code></pre>