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
Maxim Demenko wrote:
> Chuck schrieb:
>> 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.
You fail to show the pertinent data from the table. Please run this query...
select max(length(col1)+length(col2)+length(col3)+length(col4)) from bs;
Then add to that number the overhead bytes explained in the note. This is how index key lengths have been calculated since I started with version 7.0. Only the overhead bytes have changed due to changes in the ROWID. As I stated in the OP. This *WORKS* on a 9.2.0.5 instance. The exact same DDL, extracted from the 9205 instance and applied to the 9206 instance does not work. Received on Thu Jun 22 2006 - 10:32:58 CDT