RCU 11g Fails When Creating Index on MDS_COMPONENTS - " ORA-01450: maximum key length (6398) exceeded "
Last updated on SEPTEMBER 07, 2016
Applies to:
Oracle Fusion Middleware - Version 11.1.1.2.0 and laterInformation 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 )
- SOAINFRA - SOA Infrastructure
- MDS - Metadata Services
- ORASDPM - User Messaging Service
- ORABAM - Business Activity Monitoring
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)
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