How To Estimate Time And Identify How Many Tables Are Left For Partitioning (Doc ID 1328801.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Dec-2012***
Checked for relevance on 13-Aug-2014.

Goal

On January 21, 2011, the user has done partitioning by using the below command:-


The user was doing monthly partitions.
The user only had a down time of 2 hours.
After 2 hours, this (Partitioning) activity stopped.

It has partitioned some of the tables.
There are large chunk of data in event_t, event_bal_imapcts_t, journal_t tables.
Within the down time of 2 hours, it has partitioned event_bal_impacts_t and some other tables.

The size of event_t table was 338 GB.

Is there a way of getting an estimation on how long it will take for partitioning to complete in the user's production system?
Is it possible to identify how many tables are left out for partitioning?
How can the user create new monthly partitions for next 12 months?

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