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-01450: maximum key length (3166) exceeded...

Re: ORA-01450: maximum key length (3166) exceeded...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 20 Dec 2002 08:51:50 -0000
Message-ID: <atum6j$d9o$1$8302bc10@news.demon.co.uk>

It looks like you've defined an index on a set of columns with a total defined length in excess of 3,166 bytes. It doesn't sound like a good idea for an index - but if it is, you need a bigger block size for that index as Oracle limits a single index entry to somewhere between 1/3 and 1/2 of a block. (looks like you have an 8K block size).

(Alternatively, check you column definitions, e.g. have you created all characters as varchar2(4000) as a convenience, rather than as a realistic aim ?

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Coming soon a new one-day tutorial:
Cost Based Optimisation
(see http://www.jlcomp.demon.co.uk/tutorial.html )

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____England______January 21/23


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Giovanni Azua wrote in message ...

>Hello all,
>
>How can I fix this error:
>
>ORA-01450: maximum key length (3166) exceeded
>
>TIA,
>Best Regards,
>Giovanni
>
>
Received on Fri Dec 20 2002 - 02:51:50 CST

Original text of this message

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