There's a third way to do this, and AFAIK, it's the _supported_ way to
do it: quiesce the group, run dbms_repcat.alter_master_repobject,
followed by dbms_repcat.generate_replication_support. The first option
mentioned below should be OK as well, but the second is not going to be
supported--query MetaLink to find some forum posts in which Oracle
Support says so explicitly. An advantage of using
alter_master_repobject is that you only have to run it on the Master
Definition site and changes are propagated to the other masters.
- alan.aschenbrenner_at_ihs.com wrote:
>
>
>
>
> Jay,
>
> There are at least two ways that I know of to do this. First,
> the
> method you suggested - quiesce replication, perform your changes on
> all
> databases in the replication group, re-generate replication support,
> and
> finally restart replication. (To answer you question below, yes, you
> do
> need to regenerate replication support because the object has
> changed.)
> The problem with this method is that is causes DML downtime (users
> can't
> insert, update, or delete) on all objects in the replication group.
> Selects can still be performed though.
> The second method is to use the dbms_repcat.execute_ddl
> procedure. It
> applies DDL changes through the replication system, without the need
> to
> quiesce. I've only used the execute_ddl procedure a couple times,
> but it
> worked great. However, I have read about problems with it on
> metalink, so
> you might want to research it before you try it.
>
> Here's how it's used:
>
> exec
>
dbms_repcat.execute_ddl('Rep_Group_Name','Site1,Site2,Site3,...','DDL_Command');
>
>
> Hope that helps,
>
> Alan
>
>
> Alan Aschenbrenner
> Oracle DBA
> IHS Group
> alan.aschenbrenner_at_ihs.com
>
>
>
>
>
> jaysingh1_at_optonlin
>
> e.net To:
> oracle-l_at_freelists.org
>
> Sent by: cc:
>
> oracle-l-bounce_at_fr Subject: Column
> Width Increase for Replication Object
>
> eelists.org
>
>
>
>
>
> 02/20/2004 09:02
>
> AM
>
> Please respond to
>
> oracle-l
>
>
>
>
>
>
>
>
>
> Dear All,
>
> We have to increase column width(from100 to 256) for a table which is
> part
> o our replication group. (Oracle Version 8.1.7.3)
>
> The questions are
> 1) Do we need to Quiesce Replication to increase the column width of
> the
> replication object?
>
> 2) Do we have to Re-Generate the replication object?
>
> I altered column width on both side(Using alter table command in
> commandline)
> and tested . Everything works fine. Just wanted to double confirm any
> hidden issues ,etc?
>
> Any help is really appreciated.
>
> Thanks
> Jay
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Sun Feb 22 2004 - 19:32:10 CST
