The <ora-table-compression> database configuration element

The <ora-table-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <ora-table-compression>. The use of the <ora-table-compression> element is optional. Use this element to set compression on a specific, named index or table in an Oracle database. Any value that you set at this level overrides that same value set at the global, database level. See also Configuring compression for Oracle.

The <ora-table-compression> 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-compression index-compression="true|false" table-compression="ADVANCED|BASIC|NONE">
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

The following list describes the attributes that you can configure on the <ora-table-compression> element. All of these attributes are optional.

index-compression

Boolean. Whether to use index compression. Valid values are:

  • true – Use compression for all indexes on this table.
  • false – Do not use compression for the indexes on this table.

If you do not specify this attribute, PolicyCenter uses the database default.

table-compression

Specifies table compression for this table. Valid values are:

  • ADVANCED
  • BASIC
  • NONE

If you do not specify this attribute, PolicyCenter uses the database default.

The <ora-table-compression> element does not contain additional subelements.