My Oracle Support Banner

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

Last updated on APRIL 26, 2018

Applies to:

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


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?


To view full details, 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 a vibrant support community of peers and Oracle experts.