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).
Received on Wed Dec 11 2002 - 18:58:43 CST
