Event_partition.sql Takes More Time During Upgrade (Doc ID 1410764.1)

Last updated on APRIL 12, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version: 6.5.0.0.1 to 7.3.0.0.1 - Release: 6.5.0 to 7.3.0
Information in this document applies to any platform.

Goal

Customer feels the upgrade scripts take too much time. This is due to the time taken by event_partition.sql script during 65_73 upgrade as it is dropping and recreating the indexes on all event_* tables. The following are some questions about this issue.
  1. Is it necessary to drop and recreate indexes for all old event_* tables?
  2. Why is the index being dropped and recreated as part of this process for old tables and already existing indexes which needs to be present in target as well?

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