Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: View Questions

Re: View Questions

From: Alan Shein <alanshein_at_erols.com>
Date: Tue, 9 Nov 1999 09:38:07 -0500
Message-ID: <809bj4$qgf$1@autumn.news.rcn.net>


Due to the data consistency model, views contain only the data that was committed at the time of the instantiation of the view.

Ken Lee <Ken.Lee_at_its.monash.edu.au> wrote in message news:38276E09.6EB4D7D9_at_its.monash.edu.au...
> Gudday,
>
> We are going to have a database containing quite a number of active
> views, maybe 50+. This database would also have a high update
> transaction rate. So I am hoping someone could help answer a couple of
> questions I have regarding views and Oracle 8.
>
> A view, when activated, creates a virtual table based on the view
> definition. The virtual table is stored in the temporary table space.
>
> While the virtual table is being built does the database take out any
> sort of lock restrictions to maintain data integrity? ie: How does
> Oracle deal with updates to the base table(s) during view activation?
>
> While the view is in use and the base table data is changed how does the
> database deal with the changes? ie: How does Oracle deal with changes
> base table(s) changes while view is in use?
>
>
> Thanks... Ken Lee
Received on Tue Nov 09 1999 - 08:38:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US