Re: Snapshot and Indexes

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/05
Message-ID: <36e06032.198271645@news.earthlink.net>#1/1

Create 'defferred' constraints, I think it's a feature of versions 8+

On Sat, 04 Mar 2000 19:00:35 GMT, 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.

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Sun Mar 05 2000 - 00:00:00 CST