My Oracle Support Banner

NightlyBatchCleanup Fails with "ORA-14086: A Partitioned Index May Not Be Rebuilt As A Whole" Error (Doc ID 2550525.1)

Last updated on JUNE 04, 2019

Applies to:

Oracle Retail Price Management - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms



The Nightly Clean Batch (NightlyBatchCleanup) fails due to the below-mentioned error messages while running in the pre mode.

Errors
-----------------------
Error when executing the statement 'alter index RPM_BULK_CC_PE_ITEM_I1 rebuild': -14086:ORA-14086: a partitioned index may not be rebuilt as a whole

Error when executing the statement 'alter index RPM_BULK_CC_PE_ITEM_I2 rebuild': -14086:ORA-14086: a partitioned index may not be rebuilt as a whole

Error when executing the statement 'alter index RPM_BULK_CC_PE_ITEM_I3 rebuild': -14086:ORA-14086: a partitioned index may not be rebuilt as a whole



Steps to Reproduce
-----------------------
The issue can be reproduced at will with the following steps:
1. Execute the nightlyBatchCleanup batch in the pre mode.
2. Notice the error.



Changes

 

Cause

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
Symptoms
Changes
Cause
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.