View Single Post

   
  #1 (permalink)  
Old 04-08-2008, 11:13 AM
cheeky
 
Posts: n/a
Default Updatable Materialized View and Master Table on same database

Hi all,
My first question - Is it possible to have an Updatable Materialized
View and the associated Master Table located on the same database?

This is the requirement scenario:
One unique database D exists.
A is a batch table. Only inserts are allowed on Table A.
M is an updatable materialized view on Table A (Master). Only updates
are allowed on M (no insert or delete).
Requirement is to push updates/changes from M to A periodically and
then get the new inserted records from A into M via a refresh.

Is this possible? What other approaches are applicable here?

Reply With Quote