Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

SIEBEL REPOSITORY UPGRADE UTILITY FAILING WITH ERROR: "ORA-30556: either functional or bitmap join i

edited Jan 20, 2023 12:24PM in Siebel System Admin, Install and Upgrade (MOSC) 6 commentsAnswered

Hello Siebel Experts,

We are performing the Siebel Upgrade from IP16.8 -> IP22.11 and during Upgrep process we encountered below error :

ORA-30556: either functional or bitmap join index is defined on the column to be modified" FOR S_CL_SUBJ_LS Table


alter table S_CL_SUBJ_LS modify

"SUBJ_INITL"                    varchar2(30 char)

2023-01-19 10:21:20    [1076673536][ODBC 20101 driver][20101]ORA-30556: either functional or bitmap join index is defined on the column to be modified

2023-01-19 10:21:20    60: [1076673536][ODBC 20101 driver][20101]ORA-30556: either functional or bitmap join index is defined on the column to be modified

2023-01-19 10:21:20    alter table S_CL_SUBJ_LS modify;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center