search cancel

ORA-01450: maximum key length (6398) exceeded

book

Article ID: 201929

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

The below index cannot be created in AL32UTF8 with all the columns mentioned in the DDL.

Errors seen:

ORA-39083: Object type INDEX:"CLARITY"."ODF_UI_VIEWS_U1" failed to create with error:

ORA-01450: maximum key length (6398) exceeded

Failing sql:

CREATE UNIQUE INDEX "CLARITY"."ODF_UI_VIEWS_U1" ON "CLARITY"."ODF_UI_VIEWS" (NLS_UPPER("NAME"), "TYPE", "OWNER", "ASSOCIATED_INSTANCE_ID", "VIEW_MODE", "ASSOCIATED_OBJECT_TYPE", "VIEW_CLASSIFIER") PCTFREE...TABLESPACE "INDX_SMALL" PARALLEL 1

Cause

This is due to the data in the table exceeding the block size limit.

Environment

Release : All Supported

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

Create a new tablespace at a higher block size (example 16k, if at 8k) to accommodate the index.