Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Materialized view

Status
Not open for further replies.

teqmem

Programmer
Nov 26, 2004
114
US
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:
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top