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:[EMAIL PROTECTED] `~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Paul Baumgartel
<treegarden@yahoo To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
.com> cc:
Sent by: Subject: Re: Oracle Advanced
Replication
[EMAIL PROTECTED]
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.
--- [EMAIL PROTECTED] 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:[EMAIL PROTECTED] `~`~
> ~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
