My Oracle Support Banner

Exalytics OBIEE 11g: Error "ORA-01450: Maximum Key Length (6398) Exceeded On CREATE INDEX" While Trying to Create RCU Schemas on A 12c Database ( (Doc ID 2413171.1)

Last updated on APRIL 01, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Oracle Exalytics Software - Version and later
Linux x86-64


While trying to create new OBIEE RCU schemas on a 12c Database ( it fails with error:

2018-06-07 12:54:28.104 rcu:Extracting Statement from File Name: '\\deltedata\userdata\Y0BX\PRV-Y0BX\Downloads\rcu_home\\rcu\integration\\dacx\scripts\oracle\create_tables.sql'Line Number: 1947
2018-06-07 12:54:28.104 rcu:Extracted SQL Statement: [CREATE INDEX W_ETL_DEFN_PRM_M4 ON W_ETL_DEFN_PRM(ETL_DEFN_WID, VALUE)
2018-06-07 12:54:28.104 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 1450SQLState:72000 Message: ORA-01450: maximum key length (6398) exceeded


Tried the solution suggested in <Note 1483760.1>  -OBIEE 11g: Error: "ORA-01450: maximum key length (6398) exceeded File:D.....\cremdsinds.sql" When Running RCU Installation , database already has a 'BYTE' value for the nls_length_semantics.



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

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