Oracle 11g database upgrader error "ORA-01450: maximum key length (6398) exceeded"

book

Article ID: 159645

calendar_today

Updated On:

Products

Data Loss Prevention Enforce

Issue/Introduction

During the database upgrade portion of the Oracle 10g to 11g upgrade, you receive the error:

ORA-01450: maximum key length (6398) exceeded


The following entry is also in the Oracle_Server.log file:

ALTER TABLE MGMT_CHANGE_AGENT_URL
2     ADD CONSTRAINT MGMT_CHANGE_AGENT_URL_PK
3         PRIMARY KEY (last_emd_url, emd_url)
4         USING INDEX;
ALTER TABLE MGMT_CHANGE_AGENT_URL
*
ERROR at line 1:
ORA-01450: maximum key length (6398) exceeded

Resolution

This warning can be ignored and the database upgrade continued per engineering.