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

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 20 Dec 2002 19:51:35 +1100
Message-ID: <bJAM9.6885$jM5.19875@newsfeeds.bigpond.com>

Visit http://tahiti.oracle.com, where you can search for any error message and learn what to do about it. In this particular case,

"The combined length of all the columns specified in a CREATE INDEX statement exceeded the maximum index length. The maximum index length varies by operating system. The total index length is computed as the sum of the width of all indexed columns plus the number of indexed columns. Date fields have a length of 7, character fields have their defined length, and numeric fields have a length of 22. Numeric length = (precision/2) + 1. If negative, add +1."

And your response should be:

"Select columns to be indexed so the total index length does not exceed the maximum index length for the operating system. See also your operating system-specific Oracle documentation."

In other words, this sounds like a particularly daft index you're trying to create.

Regards
HJR "Giovanni Azua" <bravegag_at_hotmail.com> wrote in message news:atukvo$2q8b5$1_at_ID-114658.news.dfncis.de...
> 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:35 CST