updateable materialized views

From: moe <mohamad_wahidi_at_hotmail.com>
Date: 8 Dec 2005 20:07:02 -0800
Message-ID: <1134101222.340971.272670@f14g2000cwb.googlegroups.com>

Hi Everyone,

Ive been struglling with implementing updateable materialized views. I have a master and slave database.

I susccessfully created the materialized view using: create materialized view replication for update as select * ...
when i try to create the materialized view group im getting the errors below.
I did run catrep.sql as mentioned in oracle documentation. the sql executed
with some errors. Not sure if this is why im having problems SQL> DECLARE
2 CREATE_MVIEW_REPGROUP VARCHAR2(10);
3 BEGIN
4 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
5 gname => 'REP_GP1',
6 master => 'DBLINK1',
7 propagation_mode => 'ASYNCHRONOUS' );
8 END;
9 /
DECLARE
*
ERROR at line 1:

ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2_at_DBLINK1'
ORA-06550: line 1, column 8:

PL/SQL: Statement ignored

ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UNTRUSTED_at_DBLI
ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2394
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1699
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 4

i need some guidance on what the error means so that i can proceed  

Thanks in advance

Moe Received on Thu Dec 08 2005 - 22:07:02 CST