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

The <ora-table-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <ora-table-date-interval-partitioning>. The use of the <ora-table-date-interval-partitioning> element is optional. Use to add date range partitioning to a specific, named table in an Oracle database.

The <ora-table-date-interval-partitioning> element has the following syntax. The following code sample shows required attributes in bold font.

<database>
  <upgrade>
    <ora-db-ddl>
      <ora-table-ddl table-name="string">
        <ora-table-date-interval-partitioning datecolumn="string"
              interval="DAILY|MONTHLY|QUARTERLY|WEEKLY|YEARLY">
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <ora-table-date-interval-partitioning> element.

datecolumn

Required. Name of the column to use for the date range. The column must be non-nullable and one of the following types:

  • datetime
  • dateonly

interval

Required. The interval for each partition. Valid values are:

  • DAILY
  • MONTHLY
  • QUARTERLY
  • WEEKLY
  • YEARLY

The <ora-table-date-interval-partitioning> element does not contain additional subelements.