RMB Database CLOB Column Storage Question (Doc ID 2121968.1)

Last updated on JUNE 16, 2017

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.2.4.2 and later
Information in this document applies to any platform.

Goal

On : ORMB 2.2.4.2 version, DB - Database

RMB Database CLOB Column Storage Question

On Tables like F1_OUTMSG, there are 4 CLOB columns XML_SOURCE, ERROR_DTL, XML_RAW_RESPONSE, and XML_RESPONSE.

We are planning to convert table clob storage clause from BASICFILES to SECUREFILES to improve read/write performance and also save storage.

Please let us know if ORMB product has any limitations or issues to this approach?

Qn1:Any thing in the metadata within application that we need to change or would you see this as just a simple alter DDL at table level with index rebuilds?
 
Qn2:Do we need to update any metadata with in application configuration like in ConfigLab to reflect the way CLOB is stored?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms