Re: updateable snapshot

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
> 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?
> >
> > Master database
> > ---------------
> > SQL>sqlplus SYS/sys123_at_testdb
> > SQL>create user xyx identified by xyz;
> > SQL>grant connect to xyz;
> > SQL>grant resource to xyz;
> > SQL>commit;
> > SQL>exit
> >
> > ** But 10 minutes later, record (2000, 'New value') is vanished from
> > the snapshot 'zsup' and it does not update the master table 'z'. Only
> > 1 record is found on both master table and snapshot table.
> >
> > I want to update master table thru the snapshot. Is it possible? Is it
> > a bad work? Any clue would be appreciated?
> >
> >
> > MC

Jusung Yang
Are there any difference between 'DBMS_REPCAT.CREATE_MVIEW_REPGROUP' and 'DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP' procedure?

--MC Received on Sat Apr 26 2003 - 08:42:10 CDT