Re: Index Limit

Hello,

The index length is limited, on Oracle 7 it was about 500 Bytes length. So 3218 seems to be a Oracle 8 or 8i. If you use Oracle 8i then you can use a Intermedia Text index. If you use it for fast retrieval of the content this would be the right option.

HTH Det

In article <#5r3XN2LAHA.327_at_net025s>,
  "Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote:
> 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.
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 06 2000 - 06:25:08 CDT