Hello,
Has anyone successfully implemented an updatable materialized view in Oracle 9.x? I'm trying to follow a Oracle Metalink doc 123560.1 but running into a problem with this statement on the snapshot site:
This statement always comes back with:
At the beginning at the doc, I successfully executed the following on the master site:
Thank you.
Has anyone successfully implemented an updatable materialized view in Oracle 9.x? I'm trying to follow a Oracle Metalink doc 123560.1 but running into a problem with this statement on the snapshot site:
Code:
BEGIN
DBMS_REPCAT.CREATE_SNAPSHOT_REPGROUP(
gname => '"GROUPA"',
master => 'LINC-DEV2.WORLD',
propagation_mode => 'ASYNCHRONOUS');
END;
/
This statement always comes back with:
Code:
ORA-23313: object group "PUBLIC"."GROUPA" is not mastered at LINC-DEV2.WORLD
At the beginning at the doc, I successfully executed the following on the master site:
Code:
BEGIN
DBMS_REPCAT.CREATE_MASTER_REPGROUP(
gname => '"GROUPA"',
qualifier => '',
group_comment => '');
END;
/
Thank you.