My Oracle Support Banner

Error "ORA-30556: either functional or bitmap join index is defined on the column to be modified" While Performing Siebel Version Upgrade (Doc ID 1601564.1)

Last updated on APRIL 18, 2023

Applies to:

Siebel System Software - Version 17.0 [IP2017] and later
Siebel eMedia - Version 17.0 [IP2017] and later
Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

During the Siebel upgrade, the following error is reported in ddlctl_tab.log file.

2013-11-03 22:12:07 SQL Statement:
alter table S_CONTACT modify
"EMAIL_ADDR" varchar2(350 char)
2013-11-03 22:12:07 [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified

2013-11-03 22:12:07
2013-11-03 22:12:07 S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-30556: either functional or bitmap join index is defined on the column to be modified
2013-11-03 22:12:07
2013-11-03 22:12:07 alter table S_CONTACT modify
2013-11-03 22:12:07 "EMAIL_ADDR" varchar2(350 char)
2013-11-03 22:12:07
2013-11-03 22:12:07 ;
2013-11-03 22:12:07 writeExecDDL error (UTLOdbcExecDirectDDL pDDLSql).
2013-11-03 22:12:07 writeExecDDL error (UTLDbDdlColModify).
2013-11-03 22:12:07 Error in MainFunction (UTLDbDdlDbMerge).
2013-11-03 22:12:07 Error in Main function...
2013-11-03 22:12:07 (logapi.cpp (184) err=1 sys=0) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 0, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

This is applicable to both Oracle and MS SQL Server databases.

Changes

Issue coming while performing the Siebel version Upgrade

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.