The <ora-lobs> database configuration element

The <ora-table-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 attributes for LOB columns on a specific, named table in an Oracle database. Any value that you set at this level overrides that same value set at the global, database level.

The <ora-lobs> 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-lobs caching="true|false" type="BASIC|SECURE|SECURE_COMPRESSED/>>
      </ora-table-ddl>
    </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

Sets the LOB cache attribute for the named Oracle table. The default is false.

type

Sets the LOB type for the named Oracle table. 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.