Oracle database compression

You can specify Oracle database compression options for PolicyCenter by using the <ora-compression> element of <ora-db-ddl> in database-config.xml. The <ora-compression> element has the following syntax:

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

The <ora-compression> element accepts the attributes table-compression and index-compression. You can specify one or both attributes. Attributes that you specify for <ora-compression> apply to all tables and indexes in the database.

The values that you can set for these two attributes are described in the topics that follow.

See also

• The <ora-db-ddl> database configuration element