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: unique indexes for snapshots

Re: unique indexes for snapshots

From: Helen Macduff <Helen.Ward_at_alcatel.com.au>
Date: Tue, 19 Oct 1999 16:19:56 +1000
Message-ID: <380C0D8C.CDFB4F12@alcatel.com.au>


When a snapshot is updated oracle will not guarantee the manner in which they do this or that they wont change the way in which they do it in the future. It is possible that an insert may be done before a delete on the same unique key and momentarily the unique constraint will be violated

"Maija-Leena Kangasmäki" wrote:
>
> Hi,
>
> can anybody explain why unique indexes aren't allowed for snapshots ?
> I've been testing it and haven't found any problems so I'd like to know
> the situation in which it causes problems.
>
> Thanks !
>
> Regards,
>
> Maija-Leena Kangasmäki
>
> maija-leena.kangasmaki_at_tietoenator.com
Received on Tue Oct 19 1999 - 01:19:56 CDT

Original text of this message

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