Re: [8i] Local unique indexes on a partitionned table

From: Frederic Payant <fpayant_at_club-internet.fr>
Date: Thu, 13 Jun 2002 21:55:20 +0200
Message-ID: <v6shgu8s9d7ncpkt3rc1mckpts8ivqdk4a@4ax.com>

It can be an issue, I'll see with developpers if they can ensure logically uniqueness.

Thanks for your proposition

Nuno Souto <nsouto_at_optushome.com.au.nospam> :

>In article <b6525ebd.0206120123.574297df_at_posting.google.com>, you said
>(and I quote):
>>
>> Are there other ways to ensure the uniqueness of the key ?
>>
>
>PMFJI.
>
>By design? As in making sure some component of the unique key is ensured
>to be unique. For example, make the unique key a combo of a sequence-
>generated number and a partition prefix.
>Or some other mechanism involving date/time stamp.

Regards
Frederic PAYANT - junior DBA ;-) Received on Thu Jun 13 2002 - 14:55:20 CDT

Re: [8i] Local unique indexes on a partitionned table - Is it possible ?