Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Index Limit
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