The <ora-db-ddl> database configuration element

The <upgrade> element in file database-config.xml contains, at most, a single occurrence of subelement <ora-db-ddl>. The use of the <ora-db-ddl> element is optional. Use this element to set Oracle database DDL (Data Definition Language) options during the creation of new objects in the database. This configuration applies to the database at a global level.

The <ora-db-ddl> element has the following syntax. The following code sample shows required attributes in bold font.

<database>
  <upgrade
    <ora-db-ddl>

       <!-- Sets Oracle database options at the global, database level -->
      <ora-compression index-compression="true|false" table-compression="ADVANCED|BASIC|NONE"/>
      <ora-lobs caching="true|false" type="BASIC|SECURE|SECURE_COMPRESSED/>
      <tablespaces admin="string" index="string" lob="string" op="string" staging="string"
            typelist="string"/>

       <!-- Sets Oracle options for the named table, overrides values set at the database level -->
      <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>

There are no specific attributes on the <ora-db-ddl> element.

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

ora-compression

Specifies Oracle compression settings for all tables and indexes at the global, database level. See The <ora-compression> database configuration element for more information.

ora-lobs

Specifies attributes for LOB columns on all tables at the global, database level. See The <ora-lobs> database configuration element for more information.

ora-table-ddl

Specifies DDL parameters and overrides for a specific, named Oracle database table. See The <ora-table-ddl> database configuration element for more information.

tablespaces

Specifies default mappings for Oracle tablespaces at a global, database level. See The <tablespaces> database configuration element for more information.

See also