Re: Snapshot and Indexes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/06
Message-ID: <38C38645.7620@yahoo.com>#1/1

ydias_at_hotmail.com wrote:
>
> Hi everybody,
>
> I create snapshots between two databases. In the target database, the
> snaphots are used for complex queries. Oracle creates tables named
> SNAP$Snaphot_name for each snapshot. Can I create indexes on these
> tables.
>
> Thank you.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

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

Received on Mon Mar 06 2000 - 00:00:00 CST