Siebel Business Process & Functionality (MOSC)

MOSC Banner

Siebel DB Upgrade Wizard - Change Index to Not-Unique

edited Apr 10, 2015 10:01AM in Siebel Business Process & Functionality (MOSC) 2 commentsAnswered

Hi,

is it possible to change the DB-Upgrade Wizard so that he creates a Index that is not Uniqe? We have a customized Index and right now we get the follwing error:

S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

  Dropping index with the same column signature and retrying...

create unique index S_OPTY_U1 on S_OPTY

("NAME", "PR_DEPT_OU_ID", "BU_ID", "CONFLICT_ID")

tablespace XELLA_IND

;

S0012: [DataDirect][ODBC Oracle driver][Oracle]ORA-01418: specified index does not exist

drop index S_OPTY_U1

;

Dropping index S_OPTY_U1 ... 0.004s

S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

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