E-DM: While Creating PeopleTools 8.55 System Database The Import Fails With ORA-01450: Maximum Key Length (6398) Exceeded

(Doc ID 2235750.1)

Last updated on MARCH 17, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.

Symptoms

When attempting to install 8.55 System Database the following error occurs:


CREATE INDEX PSOPSPMTRANSHIST ON PSPMTRANSHIST
CREATE UNIQUE INDEX PS_PSPTDEFSEC_GRP ON PSPTDEFSEC_GRP
CREATE INDEX PSAPTIAADSPRJCALC ON PS_PTIAADSPRJCALC
CREATE INDEX PSAPTIASPOBJDIFF ON PS_PTIASPOBJDIFF

Allow of the above failed with error:
- SQL Error. Error Position: 33 Return: 1450 - ORA-01450: maximum key length (6398) exceeded




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