The <ora-table-ddl> database configuration element

The <ora-db-ddl> element in file database-config.xml can contain any number of occurrences of subelement <ora-table-ddl>. The use of the <ora-table-ddl> element is optional. Use this element to set DDL parameters and overrides for a specific, named table in an Oracle database.

The <ora-table-ddl> 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-index-ddl index-compression="true|false" index-tablespace="string" key-columns="string"/>
        <ora-lobs caching="true|false" type="BASIC|SECURE|SECURE_COMPRESSED/>>
        <ora-table-compression index-compression="true|false" table-compression="ADVANCED|BASIC|NONE">
        <ora-table-date-interval-partitioning datecolumn="string"
              interval="DAILY|MONTHLY|QUARTERLY|WEEKLY|YEARLY">
        <ora-table-hash-partitioning hash-columns="string" num-partitions="integer"/>
        <ora-table-tablespaces index-tablespace="string" lob-tablespace="string"
              table-tablespace="string"/>
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

The <ora-table-ddl> element has the following attribute.

table-name

Required. Name of the table to which these overrides apply.

The subelements on the <ora-table-ddl> element have the following meanings.

ora-index-ddl

Specifies options for a specific Oracle index, based on key columns. See The <ora-index-ddl> database configuration element for more information.

ora-lobs

Specifies options for LOB columns on a specific, named table in an Oracle database. See The <ora-lobs> database configuration element for more information.

ora-table-compression

Specifies compression options on a specific, named index or table in an Oracle database. See The <ora-table-compression> database configuration element for more information.

ora-table-date-interval-partitioning

Specifies options for date range partitioning on a specific, named table in an Oracle database. See The <ora-table-date-interval-partitioning> database configuration element for more information.

ora-table-hash-partitioning

Specifies options for hash partitioning of a specific, named table in an Oracle database. See The <ora-table-hash-partitioning> database configuration element for more information.

ora-table-tablespaces

Specifies tablespace options for a specific, named table in an Oracle database. See The <ora-table-tablespaces> database configuration element for more information.

See also