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: [8i] Local unique indexes on a partitionned table - Is it possible ?

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

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 12 Jun 2002 22:10:28 +1000
Message-ID: <3d073b8c$0$28009$afc38c87@news.optusnet.com.au>


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 sequencegenerated  number and a partition prefix.
Or some other mechanism involving date/time stamp.

-- 
Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam
Received on Wed Jun 12 2002 - 07:10:28 CDT

Original text of this message

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