Free Oracle Tips   HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Replication Tips by Burleson

Adding and Removing Oracle replication Objects

Adding and removing objects is easy, provided they are not large.  Simply stop replication activity.  Add the object to the master group at the master definition site and restart replication.  The new object will be propagated to all master sites in the replication environment. 

connect repadmin/repadmin@navdb

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

BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPOBJECT(
     gname => '"GROUP1"',
     type => 'TABLE',
     oname => '"CUSTOMER"',
     sname => '"PUBS"',
SEE CODE DEPOT FOR FULL SCRIPT
     copy_rows => TRUE,
     use_existing_object => TRUE);
END;
/ 

BEGIN
      DBMS_REPCAT.RESUME_MASTER_ACTIVITY(
      gname => '"GROUP1"');

This is an excerpt from Oracle Replication By Rampant TechPress (only $19.95).  You can click here to order a copy and get instant access to the code depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Download your Oracle scripts now: www.oracle-script.com The definitive Oracle Script collection for every Oracle professional DBA