My Oracle Support Banner

ORDS 21.2 Installation Fails With "ORA-01450: Maximum Key Length (3118) exceeded" In Database 19.12 With Block Size of 4K (Doc ID 2808568.1)

Last updated on APRIL 12, 2024

Applies to:

Oracle REST Data Services - Version 21.2 and later
Information in this document applies to any platform.

Symptoms

Given Oracle Database 19.12 with db_block_size 4096, tablespace APEXORDS with block_size 8192

When trying to install ORDS 21.2 in tablespace APEXORDS the following error appears:

Error starting at line : 885 in command -

CREATE UNIQUE INDEX sec_auths_unq_provider ON
sec_authenticators (
schema_id
ASC,
provider
ASC )
Error report -
ORA-01450: maximum key length (3118) exceeded
01450. 00000 - "maximum key length (%s) exceeded"
*Cause:
*Action:
Refer to log file
/refresh/home/ords_install_core_2021-08-20_201901_00004.log for details

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
References


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