Updatable Materialized View and Master Table on same database

From: cheeky <cheekyiscool_at_gmail.com>
Date: 25 Aug 2006 10:43:12 -0700
Message-ID: <1156527792.458710.92110@i42g2000cwa.googlegroups.com>

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? Received on Fri Aug 25 2006 - 12:43:12 CDT