Home » Server Options » Replication » Help in Replication, step to create updateble M.V. (Oracle 10 g , XP)
Help in Replication, step to create updateble M.V. [message #289562] Mon, 24 December 2007 01:03 Go to next message
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
Re: Help in Replication, step to create updateble M.V. [message #289596 is a reply to message #289562] Mon, 24 December 2007 04:05 Go to previous message
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

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


Current Time: Thu Mar 28 09:41:16 CDT 2024