Re: updateable snapshot

Well, that's what an "updatable materialized view" is all about. The data you change in a materialized view will be pushed back to the master table. This can get pretty complicated, you basically are dealing with advanced replication at this point. A materiliazed view can be built on top of another materialized view. So you can have mater sites that contain master tables, master materialized view site that contain master materiliazed views and materialized view sites that contain materialized views which can be read-only, writeable or updatable.

Before you charge right into it, review what is it that you really want to accomplish so that you might pick the right solution.

• Jusung Yang

manikroy_bd_at_yahoo.com (MC) wrote in message news:<648c5dd4.0304202135.18ac8818_at_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?
>
> -- MC
>
> >
> > 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 - 12:06:21 CDT