Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unique indexes for snapshots
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