Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora-1450 even though max key length is well below the max

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 13:42:34 GMT
Message-ID: <e7xmg.10373$1G2.5315@trnddc06>


Gints Plivna wrote:

> 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?

Single byte character set on both databases - WE8ISO8859P1 Received on Thu Jun 22 2006 - 08:42:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US