RCU 11g Fails When Creating Index on MDS_COMPONENTS - " ORA-01450: maximum key length (6398) exceeded "
(Doc ID 987906.1)
Last updated on JANUARY 01, 2021
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: <ORACLE_HOME>/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: <ORACLE_HOME>/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)
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |