Re: snapshot tables

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 01 Jul 1999 12:24:53 GMT
Message-ID: <37865dd0.55718198@newshost.us.oracle.com>

A copy of this was sent to "Søren Lauritzen" <sorenl_at_rki.dk> (if that email address didn't require changing) On Thu, 1 Jul 1999 14:11:20 +0200, you wrote:

>How to create index on a snapshot table or must you create a real table.
>
>Søren, RKI
>

when you create a snapshot "X", a view "X" is created on a table named "SNAP$_X". You may index "SNAP$_X". If you create a unique index -- be careful to make it deferrable (you also need to be using Oracle8.0 or up to put a unique index on a snapshot).

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 01 1999 - 07:24:53 CDT