Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-1450 even though max key length is well below the max
Gints Plivna wrote:
>> Single byte character set on both databases - WE8ISO8859P1
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