My Oracle Support Banner

COMPACT_SUB_EVENT Column Drop Optimization During PS20 Installation (Doc ID 2441407.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.5.0]
Information in this document applies to any platform.


During PatchSet20 installation (from PS16) step ./sys/dd/data/drop_column_compact_sub_event.source took more than 3 hours per one database as you can see from below output:

Is there any workaround to reduce the time spent on this particular step?
If the step of column dropping is skipped, can the system operate (e.x. basic processes such as running CM, Pipelines, billing, invoicing, rating, etc.) after the entire installation is finished?
Can the column be dropped even before Patch Set installation?
Will the system operate correctly on PS16 with dropped column?
Will PS20 installation not fail due to already dropped column?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.