DB Upgrade to 12.2.0.1 fails with Error ORA-01450: Maximum Key Length (3118) Exceeded - create unique index i_radm_pe1 on sys.radm_pe$(pe_name) (Doc ID 2268981.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Error during 12.2.0.1 upgrade

15:42:09 SQL>
15:42:09 SQL> Rem
15:42:09 SQL> Rem lrg #19690342: Data Redaction fix for re-upgrade.
15:42:09 SQL> Rem Cannot truncate the radm_pe$ table here, as the upgrade script
15:42:09 SQL> Rem may be re-run after a Data Redaction Policy has been upgraded
15:42:09 SQL> Rem to the 12.2-format by the PL/SQL block below (see the "Copy each
15:42:09 SQL> Rem existing Policy Expression..." comment).
15:42:09 SQL> Rem
15:42:09 SQL>
15:42:09 SQL> create unique index i_radm_pe1 on sys.radm_pe$(pe_name)
15:42:09 2 /
create unique index i_radm_pe1 on sys.radm_pe$(pe_name)
*
ERROR at line 1:
ORA-01450: maximum key length (3118) exceeded


Elapsed: 00:00:00.02
15:42:09 SQL> create index i_radm_pe2 on sys.radm_pe$(pe_obj#, pe_name)
15:42:09 2 /
create index i_radm_pe2 on sys.radm_pe$(pe_obj#, pe_name)
*
ERROR at line 1:
ORA-01450: maximum key length (3118) exceeded




 

Changes

Upgrading database to 12.2.0.1

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