Unable to Sync New Table USER_ACTIVITY_EVENT_LIST_T As Part of /user_activity Class During Upgrade

(Doc ID 2307081.1)

Last updated on SEPTEMBER 21, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Goal

On Oracle Communications Billing and Revenue Management (BRM) version 7.5.0.16.0, when upgrading BRM 7.5 from PS9 to PS16, as part of that upgrade, there is a step to create a new table "USER_ACTIVITY_EVENT_LIST_T" as part of class /user_activity.

The main table of class is partitioned on a monthly basis, but after the upgrade, the new table only has the PARTITION_LAST partition.  It is required to sync future partitions of the new table with partitions of the old main table and which also need to drop OLD partitions on class /user_activity.

Attempts to use the following commands do not resolve this issue.

partition_utils -o update -c /user_activity
partition_utils -o update -c /user_activity -f

Question: In both cases partitions were not created, what is/are the correct command(s) to be used?

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