Siebel 8.1.1.11 IRM - Siebel Database Configuration Wizard Fails With Error ORA-30556
(Doc ID 1622613.1)
Last updated on JULY 22, 2021
Applies to:
Siebel Public Sector Call Center - Version 8.1.1.11 [IP2013] and laterInformation in this document applies to any platform.
Symptoms
Running Siebel upgrade from version 8.1.1.7 SIA to 8.1.1.11 in the Development environment.
When running the Upgrade - Upgrep process, at the Step "Run the Siebel Database Configuration Wizard under WIndows" , it errors out with the following :
2013-11-06 15:09:31 SQL Statement:
alter table S_CONTACT modify
"EMAIL_ADDR" varchar2(350 char)
2013-11-06 15:09:31 [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-06 15:09:31
2013-11-06 15:09:31 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-06 15:09:31
2013-11-06 15:09:31 alter table S_CONTACT modify
2013-11-06 15:09:31 "EMAIL_ADDR" varchar2(350 char)
In 8.1.1.7 version, case insensitivity search is configured on the S_CONTACT.EMAIL_ADDR field .
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 |