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

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Thu, 22 Jun 2006 14:56:57 GMT
Message-ID: <Zcymg.10382$1G2.4365@trnddc06>

Gints Plivna wrote:

>> Single byte character set on both databases - WE8ISO8859P1

>
> Yea but you said that error message gave you 3118. But looking at your
> table definition -length of both varcahr2 columns together (2000 +
> 2000) is more than 3118.
> So at least the error message is completely justifiable.
>
> Gints Plivna
> http://www.gplivna.eu/
>

You can't determine key length by adding the max defined size of the columns. To determine key length you must query max(length(col1)+length(col2)...) + number of columns.

See metalink note # 136158.1. Received on Thu Jun 22 2006 - 09:56:57 CDT