Oracle 9i replication trouble

From: dk <cxdk_at_km.ru>
Date: 26 Dec 2003 05:17:09 -0800
Message-ID: <1bf754cb.0312260517.695557dd@posting.google.com>

trying 2 set up a materialized view replication on oracle 9i

do everything according 2 documentation.. while creating a mview_repobject

BEGIN
   DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (

      gname=> 'testrep',
      sname => 'scott',
      oname => 'a',
      type => 'SNAPSHOT',
      min_communication => TRUE);

END; get the following error:

ORA-23454: flavor  not defined for object group "PUBLIC"."SCOTT"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 452
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 468
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5523
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at line 2

all dblinks, rep_group, mview_group, tables, mview, mview_logs etc. seem 2 b ok..

would b grateful 4 any advises.. Received on Fri Dec 26 2003 - 07:17:09 CST