RCU 11g Fails When Creating Index on MDS_COMPONENTS - " ORA-01450: maximum key length (6398) exceeded "

(Doc ID 987906.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

Oracle Fusion Middleware - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
Checked for currency on 23-Aug-2013

Symptoms

The objective is to create the following Oracle Fusion Middleware 11g schemas using the Repository Creation Utility ( RCU )

RCU throws the following error as it attempts to create the MDS and SOAINFRA schemas:

ORA-01450: maximum key length (6398) exceeded
File: /data/work/OIM/rcu/rcuHome/rcu/integration/mds/sql/cremdsinds.sql
Statement: create index MDS_COMPONENTS_N1
on MDS_COMPONENTS (COMP_LOCALNAME, COMP_CONTENTID,
COMP_PARTITION_ID, COMP_NSID, COMP_SEQ, COMP_ID)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms