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

Article Id: 159645

Status: Published

Updated On: 06-06-2013 15:20

Legacy Id: TECH219222

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.