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

Home -> Community -> Usenet -> c.d.o.tools -> Index Limit

Index Limit

From: Robbo7 <robbo7NoSpam_at_ozemail.com.au>
Date: Fri, 6 Oct 2000 06:03:12 +1000
Message-ID: <ud4D5.19976$O7.285509@ozemail.com.au> 






Hi,



I have a column defined as VARCHAR2(4000).  When I try to index this column
I get a message, "ORA-01450: maximum key length (3218) exceeded".  Is there
a way of changing this so that I can index my text column?  It would seem
silly if Oracle allows me a 4000 character column but won't allow me to
index it.
Received on Thu Oct 05 2000 - 15:03:12 CDT












Original text of this message













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