Is it posible to create indexes on a snapshot ?

From: Guy Dallaire <gdallair_at_criq.qc.ca>
Date: Tue, 19 Oct 1999 14:31:08 GMT
Message-ID: <380c8032.70844806@news.risq.qc.ca>

I was reading a post mentionning that one cannot create a UNIQUE index on a snapshot. But I was wondering if it is possible to create other types of indexes on a snapshot.

If it is possible, on which object does the index need to be created. Isn't a snapshot a VIEW ? I don't think we can create an index on a view, can we ? ? ?

Also, the view is based on some SNAP$... object. Should the indexes be created on this object then ?

Finally, how does oracle maintain a snapshot, will I lose my index when the snapshot gets refreshed ? I mean, does it only truncate the table or does it drop + recreate it ?

Thanks

---

Guy Dallaire, Sysadmin/DBA
Centre de recherche industrielle du Quebec Ste-Foy, QC, Canada
http://www.criq.qc.ca
e-mail: gdallair_at_criq.qc.ca
ICQ: 18846092 Received on Tue Oct 19 1999 - 09:31:08 CDT