Re: updateable snapshot

From: MC <manikroy_bd_at_yahoo.com>
Date: 20 Apr 2003 22:35:04 -0700
Message-ID: <648c5dd4.0304202135.18ac8818@posting.google.com>

JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0304200903.311e6a55_at_posting.google.com>...
> There are 3 types of Materialized Views: read-only, updatable and
> writeable. Yours is writeable, not updatable. You can change data in a
> writeable MV, but the data will not be pushed to the master table, and
> the changes will be lost when the next refresh occurrs and the MV is
> refreshed with data from the master table. To make an MV updatable, it
> needs to be in a "Materialized View Group". Look up
> DBMS_REPCAT.CREATE_MVIEW_REPGROUP, DBMS_REPCAT.CREATE_MVIEW_REPOBJECT
> and ORACLE mannual on how to use them.
>
>
> - Jusung Yang

Jusung Yang,

Thanks for your response and correction 'writeable MV/snapshot'. Do you think it is impossible to update/insert into master database thru MV/snapshot?

>
> manikroy_bd_at_yahoo.com (MC) wrote in message news:<648c5dd4.0304192114.348e8ad4_at_posting.google.com>...
> > Hello everyone,
> >
> > Could somebody help me on the following issue...
> >
> > ** Is updateable snapshot able to update master table?
> >
> > If yes then where is the problem that I do?
Received on Mon Apr 21 2003 - 00:35:04 CDT