Configuration options for Oracle tablespaces

To specify tablespaces for Oracle, use the following syntax in your database configuration in database-config.xml:

<database>
...
  <upgrade>
    <ora-db-ddl> 
      <tablespaces admin="admin tablespace" index="index tablespace" op="op tablespace"
       staging="staging tablespace" typelist="typelist tablespace" lob="lob tablespace" />
    </ora-db-ddl>
  </upgrade>
</database>

To specify tablespaces for a particular table in Oracle, use the following syntax in your database configuration in database-config.xml:

<database>
...
  <upgrade>
    <ora-db-ddl> 
      <tablespaces admin="admin tablespace" index="index tablespace" op="op tablespace"
       staging="staging tablespace" typelist="typelist tablespace" lob="lob tablespace" />
      <ora-table-ddl table-name="table name">
        <ora-table-tablespaces table-tablespace="table tablespace" lob-tablespace="LOB tablespace"
         index-tablespace="index tablespace"/>
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>