Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01450: maximum key length (3166) exceeded...
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 ...Received on Fri Dec 20 2002 - 02:51:50 CST
>Hello all,
>
>How can I fix this error:
>
>ORA-01450: maximum key length (3166) exceeded
>
>TIA,
>Best Regards,
>Giovanni
>
>