title: Tablespaces with interval partitioning
body: <p>Is there any way to specify different tablespaces for each partition if I use <a href="https://oracle-base.com/articles/11g/partitioning-enhancements-11gr1#interval_partitioning" rel="nofollow">interval partitioning</a>?</p>
  
  <p>My table is (it is just example, I have more columns in the table):</p>
  
  <pre><code>create table MY_TABLE
  (
    id                        NUMBER(20) not null,
    type                      VARCHAR2(1 char) not null,
    session_id                NUMBER(12) not null,
    date_of_beginning         DATE not null,
    account_number            NUMBER not null
  )
  PCTFREE 1
  PARTITION BY RANGE (date_of_beginning) 
  INTERVAL(NUMTOYMINTERVAL(1, ''MONTH'')) 
  SUBPARTITION BY HASH(account_number) subpartitions 50
  (  
     PARTITION p_1 VALUES LESS THAN (TO_DATE(''01.06.2015'', ''dd.mm.yyyy''))
  )';
  </code></pre>
  
  <p>I want each partition to be stored in separate tablespase. Any ideas how can I achieve it?  Maybe some trigger?</p>
  
  <p>For other tables like this one, we have a job, which creates tablespace and partition in the beginning of the month. But this one creates partitions automatically because of intervals.</p>