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
] 
Blog
Search
Help
Members
Register
Login
Home
