Re: updateable materialized views

moe <mohamad_wahidi_at_hotmail.com> wrote:
> 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

To my unarmed eye it looks like a stored procedure you are calling is trying to do something with SYS.DBMS_REPCAT_UTL2_at_DBLINK1 and SYS.DBMS_REPCAT_UNTRUSTED_at_DBLINK1 and failing.

You should start investigating along these lines. Also, check if the database versions are compatible, if all system packages are there etc.

Yours,
Laurenz Albe Received on Fri Dec 09 2005 - 04:25:51 CST