My Oracle Support Banner

Creation of DB-Schema for OIM 11g R2 PS2 Fails with "java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded" (Doc ID 2045816.1)

Last updated on OCTOBER 18, 2018

Applies to:

Oracle Fusion Middleware - Version 11.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When using RCU to create the schema needed for a fresh OIM 11g R2 PS2 installation, the creation of the following users fails with "java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded" when creating MDS, OPSS, SOAINFRA schemas.

Full error stack as follows:

2015-08-12 15:57:43.631 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 1450SQLState:72000 Message: ORA-01450: maximum key length (6398) exceeded

Error encountered executing SQL statement FileName: '/oracle-save/iam-11.1.2.2/repo/installers/fmw_rcu/linux/rcuHome/rcu/integration/mds/sql/cremdsinds.sql' LineNumber: '180'
SQL Statement: [create index MDS_COMPONENTS_N1
on MDS_COMPONENTS ( COMP_LOCALNAME, COMP_CONTENTID, COMP_PARTITION_ID, ENTERPRISE_ID, COMP_NSID, COMP_SEQ, COMP_ID )
]
java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded

 

 

 

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.