Unable to Sync New Table USER_ACTIVITY_EVENT_LIST_T As Part of /user_activity Class During Upgrade
Last updated on SEPTEMBER 21, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On Oracle Communications Billing and Revenue Management (BRM) version 220.127.116.11.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.
Question: In both cases partitions were not created, what is/are the correct command(s) to be used?
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