Getting ORA-1450 Error When Trying To Create an Index Against a Table (Doc ID 579372.1)

Last updated on JULY 31, 2017

Applies to:

JDBC - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

When creating an index on a table with a combined key length of 3264, it fails when executing via JDBC with the following error.

ORA-01450: maximum key length (6398) exceeded


When executing via SQL*Plus it works fine.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms