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

Home -> Community -> Usenet -> c.d.o.server -> Re: Index problem

Re: Index problem

From: Steve Adams <steveadams_at_acslink.net.au>
Date: 1997/05/02
Message-ID: <336a2983.3355093@nntp.peg.apc.org>#1/1

On 1 May 1997 04:44:17 GMT, Ku Kam Ming <kmku_at_hkusua.hku.hk> wrote:
> I have a table :
>
> title varchar2(500),
> author varchar2(500),
> abstract varchar2(500)
>
>I cannot create index for each column as the maximum allowable length is
>758. Is this mean I cannot create index on this table? Or any other
>method?

Use a larger db_block_size. Received on Fri May 02 1997 - 00:00:00 CDT

Original text of this message

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