Re: Max lenght of primary key ??

Excuse my ignorance, but what is an 'oracle7 block size' ? It seems quite a strange restriction that (in my case) I can't create a key with a length >= 750 bytes.

Brian P. Mac Lean wrote:
>
> The Oracle7 Server Reference, Version 7.2, Chapter 5, Page 2/3:
>
> Item Type Limit
>
> columns index (or 16 columns maximum
> cluster index)
>
> indexes table no limit
>
> total size of one-half the Oracle7 block size minus some
> overhead
> indexed columns
>
> -----
 

-- 
-----------------------------------------------------------------
J.B. Ven                              | Alcatel Telecom Nederland
Phone: +31 (70) 3079130               | P.O. Box 3292 
Fax:   +31 (70) 3079191               | NL-2280 GG  Rijswijk
Work:  mailto:ven_at_ats.nld.alcatel.nl  | The Netherlands
Home:  mailto:basven_at_xs4all.nl        |
-----------------------------------------------------------------