My Oracle Support Banner

PostInstallDB Setup in 21.4 Failed with ORA-12984: Cannot Drop Partitioning Column (Doc ID 2775991.1)

Last updated on AUGUST 16, 2021

Applies to:

Siebel CRM - Version 21.4 and later
Information in this document applies to any platform.

Symptoms

While applying 21.4 patch on 20.1 Siebel smart partitioning environment it failed at PostInstallDB Setup with below error in import_cus_schema.log. 

alter table S_EVT_ACT drop column "HDM_ID"
2021-04-22 10:44:07 [1076673536][ODBC Oracle driver][Oracle]ORA-12984: cannot drop partitioning column

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Try to apply 21.4 patch on 20.1 Siebel smart partition environment 
2. While applying patch PostInstallDB Setup will be executed
3. Notice PostInstallDB Setup process completed successfully or not


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.