DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
  b=i5gtari6l74XLPkJ4s6Mi/zcMYqTgZTbhxQ9VvUwXp28Ae1KtmbPBMzk0EpzhvJxrC66TpGNl78HWivdRLyUrABsSn6bGCxx1fnXX7b067fyoNKrPjMwjjfNXGYuqo5Cpbrmflbm3MOIhs/+S6b3nsWYBOmazijZ9d9oxBgxqHw=;
Date: Sun, 20 Apr 2008 07:22:33 -0700 (PDT)
From: A Joshi <ajoshi977@yahoo.com>
Subject: Re: ** Schema change on replicated env
To: ajoshi977@yahoo.com, oracle-l@freelists.org
In-Reply-To: <311435.67392.qm@web58012.mail.re3.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-2038908364-1208701353=:90597"
Message-ID: <490019.90597.qm@web58005.mail.re3.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: ajoshi977@yahoo.com
--0-2038908364-1208701353=:90597
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,
     A column was added to a table in replication. Without doing a quisce. I know it is avoidable but it happened. Can you tell what are the implications to this and best way to recover. It is difficult to get downtime on the database. Thanks for help.

A Joshi <ajoshi977@yahoo.com> wrote:
    Hi, 
I have Oracle multi master replication setup. We are doing heavy processing and replication is behind. I need to add a column to a table. Generally this is done by doing quisce. then generate support. Right now I cannot do that quisce. Is there alternate or round about way to do this? Thanks for help. Also if column is added on the source as it is without quisce, it will work but I do not know the consequences. It is small table so I can sync it up later too. Thanks
    
---------------------------------
  Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.

       
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile.  Try it now.
--0-2038908364-1208701353=:90597
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<div>Hi,</div>  <div>&nbsp;&nbsp; A column was added to a table in replication. Without doing a quisce. I know it is avoidable but it happened. Can you tell what are the implications to this and best way to recover. It is difficult to get downtime on the database. Thanks for help.<BR><BR><B><I>A Joshi &lt;ajoshi977@yahoo.com&gt;</I></B> wrote:</div>  <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">  <DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN style="FONT-SIZE: 7.5pt; COLOR: #333366"><FONT face="Times New Roman">Hi, <BR>I have Oracle multi master replication setup. We are doing heavy processing and replication is behind. I need to add a column to a table. Generally this is done by doing quisce. then generate support. Right now I cannot do that quisce. Is there alternate or round about way to do this? Thanks for help. Also if column is added on the source as it is without quisce, it will work but I do not know
 the consequences. It is small table so I can sync it up later too. Thanks</FONT></SPAN></DIV>  <div>  <HR SIZE=1>  Be a better friend, newshound, and know-it-all with Yahoo! Mobile. <A href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ">Try it now.</A></BLOCKQUOTE><BR><p>&#32;

      <hr size=1>Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a>
--0-2038908364-1208701353=:90597--
--
http://www.freelists.org/webpage/oracle-l