B2B Table Partitioning (Doc ID 1591622.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 to 11.1.1.6.0 [Release 11gR1]
Information in this document applies to any platform.

Goal

You are attempting to partition SOA B2B tables per chapter 9 Managing Database Growth in Oracle® Fusion Middleware Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (11.1.1.6.3).


But in the B2B tables below you are encountering many instances where the CPST_INST_CREATED_TIME column contains a null value, which does not allow for proper table partitioning.

B2B_BUSINESS_MESSAGE
B2B_APP_MESSAGE
B2B_WIRE_MESSAGE
B2B_DATA_STORAGE
B2B_EXT_BUSINESS_MESSAGE

Is this a known issue?
 

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