Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id gBC5MQD17765 for ; Wed, 11 Dec 2002 23:22:26 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBC5MQ317760 for ; Wed, 11 Dec 2002 23:22:26 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id SAA65739; Wed, 11 Dec 2002 18:04:54 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0051827F; Wed, 11 Dec 2002 17:53:50 -0800 Message-ID: Date: Wed, 11 Dec 2002 17:53:50 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Winnie_Liu@infonet.com Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Winnie_Liu@infonet.com Subject: Re: Oracle Advanced Replication Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The only reason is that we have to change the primary key constraint. That's mean, we got to drop and recreate the primary key constraint. And if the replicated object is still in the replication group, it probably won't allow me to drop the primary key though. (or maybe I got it all wrong?) Thanks for your help anyway, Winnie -- <\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@ `~`~ / V \ Oracle Database Administrator `~`~ o--m-m--o Infonet Services Corporation `~`~ ##### mailto:winnie_liu@infonet.com `~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Paul Baumgartel .com> cc: Sent by: Subject: Re: Oracle Advanced Replication root@fatcity.com 12/11/02 04:58 PM Please respond to ORACLE-L Is there some reason that you can't use DBMS_REPCAT.EXECUTE_DDL? See the Supplied PL/SQL Packages reference; here's the description: ---- EXECUTE_DDL Procedure This procedure supplies DDL that you want to have executed at some or all master sites. You can call this procedure only from the master definition site. ---- This package is intended to replicate changes made to objects that belong to a replication group, so it should be suitable for use here, as well as being a whole lot simpler than the approach you'd otherwise have to take. HTH. --- Winnie_Liu@infonet.com wrote: > > To all, > > I have a 5-way multi-master replication set up on Oracle 817 and Sun > Solaris > 2.7. > > In the replication group, we would like to add a new column to a > replicated > table. > > Not only that, we would like to add this new column to the primary > key of this > replicated table. > > What are the steps that I would need to do? > > I seems to remember that if we add any new columns in the replicated > object, we > would need to > 1) quieced the whole environment > 2) drop this object from the replication group > 3) add the new column in the MDS as well as all other master sites > 4) add this table back to the replication group > 5) generate replication support > 6) resume replication again > > Would some replication expert tell me if I am correct or not? (I did > try to look > in the doc, but I can't find it any where) > > Thanks for your help! > > Winnie > > > -- > > <\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ > (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@ `~`~ > / V \ Oracle Database Administrator `~`~ > o--m-m--o Infonet Services Corporation `~`~ > ##### mailto:winnie_liu@infonet.com `~`~ > ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: Winnie_Liu@infonet.com > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: treegarden@yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Winnie_Liu@infonet.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).