My Oracle Support Banner

Is It Required To Re-Partition the Tables With Basic partitions After Upgrade (Doc ID 1939831.1)

Last updated on MARCH 23, 2019

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

Basic partitions (historic, last) exist for these tables and the is_partitioned column is 1 and partition_mode is 0 for these tables:

EVENT_BILLING_DISC_ACTION_T --> /event/billing/discount/action
EVENT_BILLING_ORDERED_GROUPS_T --> /event/billing/ordered_balgrp
EVENT_BILLING_DEAL_INFO_T --> /event/billing/deal
EVENT_BILLING_PRODUCT_ACTION_T --> /event/billing/product/action
EVENT_GROUP_SHARE_DISCOUNTS_T --> /event/group/sharing/discounts
EVENT_GROUP_SHARE_MEMBERS_T --> /event/group/sharing
EVENT_GROUP_SHARE_CHARGES_T --> /event/group/sharing/charges


Question:If partition_mode is set to 1 and re-execute partitioning process, will these tables get partitioned with partition_mode set to 1?

Solution

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.