My Oracle Support Banner

How To Estimate the Time and Identify How Many Tables Left for Partitioning (Doc ID 1328801.1)

Last updated on AUGUST 26, 2024

Applies to:

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

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 for 2 hours. After 2 hours, this (Partitioning) activity stopped.

It has partitioned only some of those 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

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.