About Oracle SecureFile LOBs

PolicyCenter supports Oracle SecureFile LOBs for unstructured data. To configure PolicyCenter to use SecureFile LOBs, modify the <database> block in database-config.xml. You can specify to use SecureFile LOBs for all LOBs in the database or for specific tables. You can also configure whether to use caching and the LOB type. The LOB type can be BASIC, SECURE, or SECURE_COMPRESSED. If not specified otherwise PolicyCenter uses SecureFile LOBs.

To specify to use basic file LOBs for all LOBs in the database, add the following to the <database> block.

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

Use the following syntax in the <database> block to specify the use of compressed SecureFile LOBs for all LOBs in the database.

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

Use the following syntax in the <database> block to specify the use of compressed SecureFile LOBs for all LOBs on a particular table.

<ora-db-ddl>
  <ora-table-ddl name="pc_tablename"> 
    <ora-lobs type="BASIC" /> 
  </ora-table-ddl> 
</ora-db-ddl>

If you configure any LOBS to be SecureFile LOBs, and:

  • You configure the LOB tablespace, you must manage the LOB tablespace with Automatic Segment Space Management.
  • You do not configure the LOB tablespace, you must manage the ADMIN, OP and STAGING tablespaces with Automatic Segment Space Management.

Use the following syntax in the <database> block to specify the use of caching for LOBs

<ora-db-ddl>
  <ora-lobs caching="true" .../>
</ora-db-ddl>

PolicyCenter does not automatically convert LOBs if you change the configuration. You can convert the tables in Oracle and then update the PolicyCenter configuration. PolicyCenter then uses the updated configuration for new objects.

Refer to Oracle documentation for information about basic file, SecureFile, and compressed SecureFile LOBs.

See also