Re: Max lenght of primary key ??

In article <33AF7685.368C_at_ats.nld.alcatel.nl>,

        Bas Ven <ven_at_ats.nld.alcatel.nl> writes:
>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.

Its a parameter set during the creation of the ORACLE instance, and is not just for ORACLE7 ... see table SYS.V$PARAMETER for the value in use in your instance
...init.ora parameter 'db_block_size'

Depending on the hardware & os architecture, ORACLE allows it to be from 512 bytes to 32K, in defined steps.

Bill

--