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).
