RE: ** advanced replication question

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 18 May 2005 10:20:58 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E0450BB76@ecogenemld50.Org.Collegeboard.local>

A Joshi,
>> advanced replication DB version 8.1.7.4
>> it possible to propagate schema changes like adding column
Yes (and No).
Is possible using ; "DBMS_REPCAT.ALTER_MASTER_REPOBJECT" but doesn't work or fails in 8i. I have tried several time in the past...there is a bug. Metalink says it is fixed but I don't think we got it to work in 8174 either? We ended up doing it manually.
Below are some my notes on this subject...I will send you directly the entire process (notes).

hth

Chris Marquez

+++++++++++++++++++

The syntax below alters a schema (table) object currently under Multimaster Replication use by;

- Stop "QUIESCED" Replication for the Master Group 
- Altering Replication Objects
- Generate support for Replication Objects 
- Start "NORMAL" Replication

In the end the Replication Tables / Object will change at all Master Sites.

NOTE: 8171 [BUG:1280292] ORA-23463/ORA-23318 from "ALTER TABLE MODIFY" in ALTER_MASTER_REPOBJECT

PROCEDURAL

Stop QUIESCE Replication Group

BEGIN

	DBMS_REPCAT.SUSPEND_MASTER_ACTIVITY(
	gname => '"RMASTER_GROUP2"');

END;
/

Alter schema Table / Object

BEGIN
DBMS_REPCAT.ALTER_MASTER_REPOBJECT(

     sname => '"RTEST1"',
     oname => '"TEST_PK_TABLE2"',
     type => 'TABLE',
     ddl_text => 'alter table RTEST1.TEST_PK_TABLE2  add(COL_3 NUMBER) ');

END;
/

...

MANUAL

The fallowing syntax and comments is an alternative manual method to applying DDL on Replicated Objects.

...

Drop Replication Object

---Drop Replication Object (from Group)
BEGIN
DBMS_REPCAT.DROP_MASTER_REPOBJECT(

     oname => '"MEMBER_WF_PAGES"',
      type => 'TABLE',
     sname => '"RESEARCH"',
     drop_objects => FALSE);

END;
/

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of A Joshi Sent: Tue 5/17/2005 5:47 PM
To: oracle-l_at_freelists.org
Subject: ** advanced replication question

Hi,

We have advanced replication DB version 8.1.7.4 Is it possible to propagate schema changes like adding column like data propagation. So it happens without having to quiesce replication. I heard it is possible with settings and it has lot of overhead. I do not know how to. Currently we have to quisce replication to do this. Thanks

Yahoo! Mail
Stay connected, organized, and protected. Take the tour

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Received on Wed May 18 2005 - 10:25:42 CDT