Oracle table compression

You can override options for all tables in the database by setting the table-compression attribute of the <ora-compression> element to NONE, BASIC or ADVANCED. For general syntax, see the preceding topic.

You can override options for a specific table by adding an <ora-table-compression> element and setting the table-compression attribute to NONE, BASIC or ADVANCED. The <ora-table-compression> element is contained in an <ora-table-ddl> element within the <ora-db-ddl> element. For example:

<database>
  ...
  <upgrade>
    <ora-db-ddl>
      <ora-table-ddl table-name="pc_tableName">
        <ora-table-compression table-compression="NONE|BASIC|ADVANCED" />
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

For the ora-table-compression table-compression attribute:

  • A value of NONE specifies that the database or table is not compressed.
  • A value of BASIC specifies that the database or table uses Oracle basic compression.
  • A value of ADVANCED specifies that the database or table uses Oracle advanced compression.
Note: Oracle advanced compression is part of the Oracle Advanced Compression Option, which requires a separate license. Refer to Oracle documentation for more information about compression.

The following example specifies advanced compression for the entire database and no compression for the pc_Activity and pc_Workflow tables.

<database name="PolicyCenterDatabase" dbtype="oracle">
  ...
  <upgrade>
    <ora-db-ddl>
      <ora-compression table-compression="ADVANCED" />
      <ora-table-ddl table-name="pc_Activity">
        <ora-table-compression table-compression="NONE" />
      </ora-table-ddl>
      <ora-table-ddl table-name="pc_Workflow">
        <ora-table-compression table-compression="NONE" />
      </ora-table-ddl>
    </ora-db-ddl>
  </upgrade>
</database>

See also