Re: Max lenght of primary key ??

The oracle block size is the basic unit of storage that oracle reads and writes, and is normally a multiple of the disk block size, say 2K, 4K, 8K for a 512 byte disk block.

Steve Phelan.

Bas Ven wrote:

> 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 |
> -----------------------------------------------------------------
Received on Tue Jun 24 1997 - 00:00:00 CDT