Re: Snapshot and Indexes

caramel98_at_my-deja.com wrote:
>
> Hi,
>
> Why this restriction ?
>
> Thank you.
>
> In article <38C38645.7620_at_yahoo.com>,
> connor_mcdonald_at_yahoo.com wrote:
> > yes but do not use unique indexes.
> >
> > HTH
> > --
> > ===========================================
> > Connor McDonald
> > http://www.oracledba.co.uk
> >
> > We are born naked, wet and hungry...then things get worse
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Oracle do not guarantee not to change the mechanism via which they create and/or refresh snapshots. Thus it is possible that there would (temporarily) be duplicate rows as a snapshot is refreshed.

Specifying a unique index (or constraint) could possibly interfere with the snapshot processing.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse