The <ora-compression> database configuration element

The <ora-db-ddl> element in file database-config.xml contains, at most, a single occurrence of subelement <ora-compression>. The use of the <ora-compression> element is optional. Use this element to set compression on Oracle database indexes and tables at a global, database level.

The <ora-compression> element has the following syntax.

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

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

index-compression

Boolean. Whether to use index compression for all indexes in an Oracle database. The default is false.

table-compression

Specifies table compression type for all tables in an Oracle database.

Valid values are:

  • ADVANCED
  • BASIC
  • NONE

The default is NONE.

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

See also