Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01450: maximum key length (1478) exceeded ?

622371Dec 3 2008 — edited Dec 8 2008

I am getting the following error when i importing into 10.2.0.4.0 database.

. . importing table "STEP_SHAPE_LEGENDS"
1820 rows imported
. . importing table "STEP_SHAPE_PARAMS"
10 rows imported
. . importing table "STEP_SUPPORT_DOCS"
447 rows imported
IMP-00017: following statement failed with ORACLE error 1450:
"ALTER TABLE "STEP_SUPPORT_DOCS" ADD PRIMARY KEY ("STEP_ID", "GROUP_ID", "I"
"D", "FILE_NAME") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INI"
"TIAL 131072 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) "
" LOGGING ENABLE"
IMP-00003: ORACLE error 1450 encountered
ORA-01450: maximum key length (1478) exceeded.

How to resolve this error?

This post has been answered by JustinCave on Dec 3 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2009

Added on Dec 3 2008

#general-database-discussions

4 comments

1,667 views