Home » Server Options » Replication » Move a talble to different tablespace in a multimaster replication
Move a talble to different tablespace in a multimaster replication [message #327865] Wed, 18 June 2008 04:14
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,


we have a production multimaster replication with 2 sites ,one is master definition site and other is master site
e.g.
BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPGROUP(
     gname => '"ISRVGRP"',
     qualifier => '',
     group_comment => '');
END;
/


Adding Objects to Master Group:

BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
     gname => '"ISRVGRP"',
     type => 'TABLE',
     oname => '"EMP"',
     sname => '"SCOTT"',
     copy_rows => FALSE,
     use_existing_object => TRUE);
END;
/

Adding Master Site (FAILOVER SITE: ISERV.FLOVGENIE):



BEGIN
   DBMS_REPCAT.ADD_MASTER_DATABASE(
     gname => '"ISRVGRP"',
     master => 'ISERV.FLOVGENIE',
     use_existing_objects => TRUE,
     copy_rows => FALSE,
     propagation_mode => 'ASYNCHRONOUS');
END;
/

Generate Replication Support for Replicated Objects:

BEGIN
   DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
     sname => '"SCOTT"',
     oname => '"EMP"', 
     type => 'TABLE',
     min_communication => TRUE,
     generate_80_compatible => FALSE);
END;
/

Resume (to start) Maultimaster Replication Activity:

BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY(gname => '"ISRVGRP"');
END;
/


Now i want to move EMP table to a different tablespace on both master definition site and master site

ALTER TABLE emp MOVE TABLESPACE users1;


My question is:
should i need to quisce the replication at master definition site and then after moving table to different tablespace i also have to regenerate replication support

1-at master definition site

BEGIN 
DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY ( gname => 'ISRVGRP');
END; 
/


2-At both master definition and master site

ALTER TABLE emp MOVE TABLESPACE users1;


3-Regenerate Replication Support

BEGIN
   DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT(
     sname => '"SCOTT"',
     oname => '"EMP"', 
     type => 'TABLE',
     min_communication => TRUE,
     generate_80_compatible => FALSE);
END;
/


4-Resume Maultimaster Replication Activity:

BEGIN
DBMS_REPCAT.RESUME_MASTER_ACTIVITY(gname => '"ISRVGRP"');
END;
/


please suggest!
thanx
Previous Topic: Two way Replication
Next Topic: Materialized View
Goto Forum:
  


Current Time: Thu Mar 28 11:31:50 CDT 2024