Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Maximum index length????

Maximum index length????

From: Tak Chi Po <tcpo_at_leland.Stanford.EDU>
Date: 28 Aug 1999 05:10:45 GMT
Message-ID: <7q7r0l$77c$1@nntp.Stanford.EDU> 





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.

Received on Sat Aug 28 1999 - 00:10:45 CDT












Original text of this message













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