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
Release : All Supported
Component : CA PPM INTEGRATIONS & INSTALLATIONS
This is due to the data in the table exceeding the block size limit.
Create a new tablespace at a higher block size (example 16k, if at 8k) to accommodate the index.