>When an updatable view is based on a table that is buffered with OPT 3, how does the tableupdate() work? If I issue table update on the view, am I just updating the buffer of the base table, or is the tableupdate() on the view updating the base table. If the tableupdate() on the view is updating the buffer on the base table i would assume that I still need to issue the tableupdate() on the base table. Am I thinking about this correctly? Confused and befuddled.
>
>TIA.
>
>John.
John,
I tired a pretty simple test. Any update to the view was pushed back to the base table no matter which opt. buffering I used.
-Mike