The <ora-lobs> database configuration element

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

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

<database>
  <upgrade>
    <ora-db-ddl>
      <ora-lobs caching="true|false" type="BASIC|SECURE|SECURE_COMPRESSED/>
    </ora-db-ddl>
  </upgrade>
</database>

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

caching

Boolean. Whether to use caching for all LOB columns on a table or for the Oracle database globally. The default is false.

type

Sets LOB type globally for the database.

Valid values are:

  • BASIC
  • SECURE
  • SECURE_COMPRESSED

The default is SECURE.

Note: SECURE and SECURE_COMPRESSED refer to the use of Oracle SecureFiles LOBs.

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

See also