Database DataWarehousing (MOSC)

MOSC Banner

DBMS_REPCAT.CREATE_MVIEW_REPGROUP problem

edited Aug 4, 2010 8:56PM in Database DataWarehousing (MOSC) 8 commentsAnswered
hello all

SQL> BEGIN
  2  DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
  3  gname => 'G_AABCS',
  4  master => 'HQ',
  5  propagation_mode => 'ASYNCHRONOUS');
  6  END;
  7  /
BEGIN
*
ERROR at line 1:
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@HQ' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UNTRUSTED@HQ' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2411
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1721
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2

please help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center