Re: Can you create an index on a snapshot?

jacob bogers wrote:
>
> Possible?

Yes - Oracle recommend that the index should not be unique or at least a unique constraint should be deferrable to ensure that the replication phase is not affected.

hth

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."