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.

(if that email address didn't require changing)

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

Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation