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
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/ >>
I would say, you interpet wrong the mentioned note, Gints is right on it. SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 22 16:59:59 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining
Scoring Engine options
scott_at_ORA102> show parameter db_block_size
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_block_size integer 8192scott_at_ORA102> create table bs(col1 varchar2(2000),col2 varchar2(2000),col3 varchar2(2000),col4 varchar2(2000));
Table created.
scott_at_ORA102> create index bs_idx on bs(col1,col2,col3,col4); create index bs_idx on bs(col1,col2,col3,col4)
*
scott_at_ORA102>
Best regards
Maxim Received on Thu Jun 22 2006 - 10:05:13 CDT