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 -> Re: Index Limit

Re: Index Limit

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Fri, 6 Oct 2000 09:00:29 +0200
Message-ID: <#5r3XN2LAHA.327@net025s>

It may seem silly to you, but I'm wondering why you want to index a Varchar2(4000) field. If it's because you're joining two tables and this field is one of the joining columns than I think you have a redundancy problem. I can't think of any other reason to index it.

But as to your question, I don't think it's possible.

Reinier.

Robbo7 <robbo7NoSpam_at_ozemail.com.au> wrote in message news:ud4D5.19976$O7.285509_at_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 Fri Oct 06 2000 - 02:00:29 CDT

Original text of this message

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