| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Advanced Replication
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
--Received on Wed Dec 11 2002 - 19:53:50 CST
<\ /> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@ `~`~ / V \ Oracle Database Administrator `~`~ o--m-m--o Infonet Services Corporation `~`~ ##### mailto:winnie_liu_at_infonet.com `~`~ ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ Paul Baumgartel <treegarden_at_yahoo To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> .com> cc: Sent by: Subject: Re: Oracle Advanced Replication root_at_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_at_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_at_infonet.com `~`~ > ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~ > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: Winnie_Liu_at_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_at_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_at_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_at_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_at_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_at_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).
 |
 |