Re: ** Schema change on replicated env
Date: Sun, 20 Apr 2008 12:01:52 -0500
A Joshi wrote:
> Thanks. I was hoping since generate support updates the $RP stored
> procedure : if there is some way to make manual change (again avoidable
> but ....). Also I will not be able to quiesce replicaition if there are
> deftran. So is there a way to store those. Like copy the deftran to a
> new table. Then delete deftran, then quiesce and do the generate
> support. then break the push job then resume replicaition. then insert
> back the saved deftran then unbreak job. Will something like this work?
Do you have a development replication environment that mirrors your production?
If so, then attempt what you have suggested on the development environment first, see if it works for you.
-- Lyndon Tiu -- http://www.freelists.org/webpage/oracle-lReceived on Sun Apr 20 2008 - 12:01:52 CDT