Re: Index Limit

Hi Det,

Thanks for the tip I will certainly look into the Intermedia Text index.

Robbo7

<moerkd_at_my-deja.com> wrote in message news:8rkcqg$lv$1_at_nnrp1.deja.com...
> 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 - 20:59:44 CDT