The <ora-index-ddl> database configuration element

The <ora-table-ddl> element in file database-config.xml can contain any number of occurrences of subelement <ora-index-ddl>. The use of the <ora-index-ddl> element is optional. Use this element to set DDL parameters and overrides for a specific Oracle index, based on key columns. See also Configuring compression for Oracle.

The <ora-index-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-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <ora-index-ddl> element.

key-columns

Required. Ordered, comma-delimited list of key columns. Specify DESC after the column name for a descending sort order on that column.

The following attributes are optional.

index-compression

Specifies the index compression for this index. If you do not specify this attribute, PolicyCenter uses the table or database default.

index-tablespaces

Name of the tablespace override for the index.

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

ora-index-partitioning

Defines partitioning for the specified Oracle index. The <ora-index-partitioning> element has the following attributes:

  • num-hash-partitions – The number of hash partitions to define. The default is 128.
  • partitioning-type – Required if using this element. Sets the partitioning type to one of the following:
    • LOCAL – Inherit the partitioning type from the table
    • HASH – Use hash partitions. If you set this attribute to HASH, then you need to specify the number of partitions to use attribute num-hash-partitions. Do not set partitioning-type to HASH if you specify an <ora-index-range-partition> subelement.
    • RANGE – Specify the range partitioning column list and the partition upper limits with one or more ora-index-range-partition elements.
  • range-partitioning-column-list – Optional. Use to specify the global range partitioning column list. This attribute requires the definition of one or more ora-index-range-partitioning elements. Do not specify the last range which is always VALUES LESS THAN (MAXVALUE). Do not use if you set attribute partitioning-type to HASH.

The <ora-index-partitioning> element contains a single subelement:

  • ora-index-range-partition – Optional. A comma-delimited, ordered list of literal values corresponding to the column list in the range-partitioning-column-list attribute. Use single quotes with string values. PolicyCenter uses this value in the clause VALUES LESS THAN(value_list). Do not use if you set attribute partitioning-type to HASH.

See also