About Oracle date interval partitioning

It is possible to configure PolicyCenter to use Oracle partitioning by date intervals.

To configure date interval partitioning on a table, add an <ora-table-date-interval-partitioning> element within <ora-table-ddl>. The <ora-table-ddl> element is a subelement of <ora-table-ddl> in the <database> element of database-config.xml. The <ora-table-date-interval-partitioning> element has following attributes:

• Use the datecolumn attribute to specify a non-nullable timestamp column for PolicyCenter to use to determine partition boundaries.
• Use the interval attribute to specify the period of time for each partition. You can set interval to DAILY, WEEKLY, MONTHLY, QUARTERLY, or YEARLY.

For example:

<database>
  ...
  <ora-db-ddl>
    <ora-table-ddl table-name="pc_table">
      <ora-table-date-interval-partitioning datecolumn="updateTime" interval="MONTHLY">
    </ora-table-ddl>
  </ora-db-ddl>
</database>

PolicyCenter stores partitioned data in the operational tablespace.

See also

• The <ora-table-date-interval-partitioning> database configuration element