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 220.127.116.11.0 and later
Information in this document applies to any platform.
On Oracle Communications Billing and Revenue Management (BRM) version 18.104.22.168.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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!