Re: Maximum index length????

A copy of this was sent to tcpo_at_leland.Stanford.EDU (Tak Chi Po) (if that email address didn't require changing) On 28 Aug 1999 05:10:45 GMT, you wrote:

>I want to create an index on a column which is of the type varchar(1000).
>
>However, I receive an error message:
>ORA-01450: maximum key length (758) exceeded.
>
>So, I go to the Oracle doc to find out that I have exceeded the maximum
>index length, which is platform specific. I am using Oracle 8.0.5 on
>Redhat Linux 6.0. Anyway to solve the problem???
>
>Thx.

the maximum index length is a function of the blocksize. you must have a 2k blocksize. On my 8k blocksize database it is:

*
ERROR at line 1:
ORA-01450: maximum key length (3218) exceeded

the max keylength is a bit less then half the blocksize.

The only way to increase your blocksize is to create a new database -- you cannot modify the blocksize of an existing database.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sat Aug 28 1999 - 09:46:58 CDT