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? |