Re: ** Schema change on replicated env
Date: Sun, 20 Apr 2008 07:22:33 -0700 (PDT)
Message-ID: <490019.90597.qm@web58005.mail.re3.yahoo.com>
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_at_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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Apr 20 2008 - 09:22:33 CDT