Re: Column Width Increase for Replication Object

From: <alan.aschenbrenner_at_ihs.com>
Date: Mon, 23 Feb 2004 09:35:37 -0700
Message-ID: <OF69AFF52C.2CA64F4D-ON87256E43.005A5AC7@ihs.com>

Paul,

    Thanks for the clarification on my "second" method not being supported. I guess we should just scratch that one off the list of methods, especially since there have been problems reported about it...

Alan

Alan Aschenbrenner
Oracle DBA
IHS Group
alan.aschenbrenner_at_ihs.com

                                                                                                                                        
                      Paul Baumgartel                                                                                                   
                      <treegarden_at_yahoo.        To:       oracle-l_at_freelists.org                                                        
                      com>                      cc:                                                                                     
                      Sent by:                  Subject:  Re: Column Width Increase for Replication Object                              
                      oracle-l-bounce_at_fr                                                                                                
                      eelists.org                                                                                                       
                                                                                                                                        
                                                                                                                                        
                      02/22/2004 06:34                                                                                                  
                      PM                                                                                                                
                      Please respond to                                                                                                 
                      oracle-l                                                                                                          
                                                                                                                                        
                                                                                                                                        

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



----------------------------------------------------------------
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 Mon Feb 23 2004 - 10:30:51 CST