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: Anurag Varma <avoracle_at_gmail.com>
Date: 22 Jun 2006 10:12:53 -0700
Message-ID: <1150996373.916413.299780@u72g2000cwu.googlegroups.com>

Maxim Demenko wrote:
> Anurag Varma schrieb:
>
> > That said, 3118 limit seems to be for a 4K block size. Are you sure
> > that your block size is 8K?
> >
>
> >
> > Anurag
> >
>
> I have just verified it on a 9.2.0.6 / Linux and got 3218 ( not 3118 )
> for 8k blocksize , on 10.2.0.1 / Linux /8k blocksize - same results as
> yours (i.e. 6398) , in the Note Chuck mentioned there are limits for 8i
> which correspond to mine. It seems, the limit is version/plattform
> dependent.
>
> Best regards
>
> Maxim

Yes, good point. I knew it was version dependent ... however, did not realize it
would vary so much in platforms.
In solaris 9.2.0.6 I get the limit as 6398 (don't remember exact figure now).

Anurag Received on Thu Jun 22 2006 - 12:12:53 CDT

Original text of this message

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