Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table(s) locked during making of snapshot ?
Snapshot is done in one select statement. Oracle has read-only consistency: all data within one select is read as at time when select is started. I.e. updates started after snapshot refresh started are not visible.
In article <3A318B6B.F1C0F59E_at_ind.alcatel.com>,
Martin Terpstra <martin.terpstra_at_ind.alcatel.com> wrote:
> If the table is not locked, does this mean that updates in the table
will
> be
> visible during the making of the snapshot ?
>
> thanks,
>
> Martin.
>
> Alex Filonov wrote:
>
> > No, table is not locked.
> >
> > In article <3A2EF725.933BB972_at_ind.alcatel.com>,
> > Martin Terpstra <martin.terpstra_at_ind.alcatel.com> wrote:
> > > hello,
> > >
> > > If I create a snapshot of a table (whole table), is this table
locked
> > > during the making of this snapshot ?
> > > I wonder because a table can be very big and therefore the
creation
> > > of a snapshot will take a while.
> > >
> > > thanks,
> > >
> > > Martin.
> > >
> > > --
> > > Martin Terpstra Alcatel CID
> > > Sr. Software Design Engineer New IP Solutions Group
> > > tel: +1 (1)408 586 1129 720 South Milpitas Blvd.
> > > fax: +1 (1)408 586 7686 Milpitas, CA 95035 USA
> > > mailto:Martin.Terpstra_at_ind.alcatel.com
http://www.ind.alcatel.com
> > >
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Dec 09 2000 - 20:07:09 CST