Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: snapshot tables
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
![]() |
![]() |