My Oracle Support Banner

Changing Monthly Partition to Daily Partition After Enabling Virtual Column (Doc ID 1995547.1)

Last updated on OCTOBER 29, 2019

Applies to:

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


This article is to clarify the impact to Oracle Communications Billing and Revenue Management (BRM) after changing the monthly partitioning scheme to daily with virtual columns enabled in the underlying Oracle database (DB).

Questions and Answers

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
Questions and Answers
 Q1. Will it be possible to change monthly partitioning to daily partitioning after enabling the virtual column?
 Q2. If there is a process in place to refresh test boxes with production snapshots which does not require bringing down applications on production system to get the snapshot (DBA uses RMAN backup), does it need the virtual column to be disabled in this case? If yes, then how?
 Q3. Any Oracle's guideline as to what should be the partition frequency ( monthly / weekly / Daily) ?

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