My Oracle Support Banner

Oracle Revenue Management and Billing (ORMB) Upgrade 2.3.0.0 To 2.3.0.1 Receive Error: ORA-00955 'CREATE UNIQUE INDEX <*>CI_BCHG_STG_CHAR_PK ON CI_BCHG_CHA (Doc ID 2549300.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.2.4.2 and later
Information in this document applies to any platform.

Goal

)RMB Upgrade 2.3.0.0 to 2.3.0.1: ORA-00955 'CREATE UNIQUE INDEX <*>CI_BCHG_STG_CHAR_PK ON CI_BCHG_CHAR:

• Upgrading indexes section gets below error:
• ERROR: ORA-00955: name is already used by an existing object (DBD ERROR: error p
• ossibly near <*> indicator at char 20 in 'CREATE UNIQUE INDEX <*>CI_BCHG_STG_CHA
• R_PK ON CI_BCHG_STG_CHAR(BCHG_STG_ID,EFFDT,SEQ_NUM) Tablespace CISTS_01 '
• ) occured while executing CREATE UNIQUE INDEX CI_BCHG_STG_CHAR_PK ON CI_BCHG_STG
• _CHAR(BCHG_STG_ID,EFFDT,SEQ_NUM) Tablespace CISTS_01
• Error Occured, Process being aborted
 

ERROR
-----------------------
ORA-00955

Why is this error occurring?
 

Solution

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
Goal
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.