Re: ora-1450 even though max key length is well below the max

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 21 Jun 2006 14:27:43 -0700
Message-ID: <1150925263.936099.255240@u72g2000cwu.googlegroups.com>

Chuck wrote:
> I should also add that the same index was created on a copy of the same
> table with no problems on a 9.2.0.5 database running on Solaris 8. The
> block size on that database is also 8k. All I did was extract the DDL
> from that DB to create the index on the other and thats when I
> encountered the problem.

What is your characterset? Haven't you multibyte charset for the failing DB?
Because firstly Oracle doesn't take length of maximal actual values but length of columns. Secondly if you have multibyte charsets then it can be * 2 or probably even * 3.

And third point is that I checked the same value on 9.2.0.5 on Linux with definitely 8K block size and here I got message

ERROR at line 1:
ORA-01450: maximum key length (6398) exceeded

So check again whether you definitely have 8 K blocks, because 3118 pretty much looks like for 4K block size ;)

Gints Plivna
http://www.gplivna.eu Received on Wed Jun 21 2006 - 16:27:43 CDT