Event_partition.sql Takes More Time During Upgrade
(Doc ID 1410764.1)
Last updated on SEPTEMBER 10, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.1 to 220.127.116.11.1 [Release 6.5.0 to 7.3.0]
Information in this document applies to any platform.
GoalCustomer 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.
- Is it necessary to drop and recreate indexes for all old event_* tables?
- 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?
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