OraFAQ Forum: Replication » Help in Replication, step to create updateble M.V.

Home » Server Options » Replication » Help in Replication, step to create updateble M.V. (Oracle 10 g , XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help in Replication, step to create updateble M.V. [message #289562]

Mon, 24 December 2007 01:03

arthik_babu
Messages: 8
Registered: December 2007

Junior Member

Hi,
Im trying to create replications of data from the M.V. site. to master site

/* AT MASTER SITE */

1. MASTER REPLICATE GROUP
2. MASTER REPLICATE OBJECT
3. REPLICATION SUPPORT
4. REPLICATION ACTIVITY
5. M.V. LOG

/* AT M.V. SITE */

1. MATERIALIZED VIEW (M.V)
2. DBMS_REFRESH.MAKE (REFRESH GROUP)

AND I AM NOT ABLE TO CREATE

1. CREATE_MVIEW_REPGROUP
2. CREATE_MVIEW_REPOBJECT

IN M.V. SITE , and i am getting following error while creating REPGROUP
CODE
SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
3 gname => 'emp_repg',
4 master => 'orc1',
5 propagation_mode => 'ASYNCHRONOUS');
6 END;
7 /

BEGIN
*
ERROR at line 1:
ORA-23374: object group "PUBLIC"."EMP_REPG" already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1688
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2

ERROR WHILE CREATING REPOBJECT AT M.V. SITE
CODE

SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPOBJECT (
3 gname => 'emp_repg',
4 sname => 'SCOTT',
5 oname => 'EMP',
6 type => 'SNAPSHOT',
7 min_communication => TRUE);
8 END;
9 /
BEGIN
*
ERROR at line 1:
ORA-23357: the propagator does not exist
ORA-06512: at "SYS.DBMS_REPCAT_CACHE", line 76
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5520
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1332
ORA-06512: at line 2

Please help me out.

Thanks in advance
------------
arthik

Report message to a moderator

Re: Help in Replication, step to create updateble M.V. [message #289596 is a reply to message #289562]

Mon, 24 December 2007 04:05

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

I'm sure your using mviewadmin user in M.V site.

Quote:

SQL> BEGIN
2 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
3 gname => 'emp_repg',
4 master => 'orc1',
5 propagation_mode => 'ASYNCHRONOUS');
6 END;
7 /

BEGIN
*
ERROR at line 1:
ORA-23374: object group "PUBLIC"."EMP_REPG" already exists
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1688
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 2

SQL> SELECT GNAME,MASTER FROM DBA_REPGROUP;

Execute the above query, If your group already exists. Try to create new group. Once create replication group after only add replication objects.

For Reference:

http://babudba.blogspot.com/2007/10/advanced-replication.html

Report message to a moderator

Previous Topic:	backup and restore
Next Topic:	Single Master Replication

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 11:53:36 CST 2025