Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: View Questions
Oracle will use rollback segment to store before image of update-committed
record, and this part of rollback segment shall be used till view is in use.
I hope this is correct.
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 - 06:34:55 CST