** adv replication

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Sun, 10 Feb 2008 14:35:49 -0800 (PST)
Message-ID: <753112.65941.qm@web58012.mail.re3.yahoo.com>

Hi,
 In case of table change alter table like add a column : for a table in adv replication : a quiesce of replication is needed and then a generate support. Now, in case of alter table like increase a field length : is it necessary to quiesce and the generate support after alter table? I think or varchar2 increase of field length it is not necessary and it can be done on the fly like it can be done for a table not in replication. The data seems to flow with the new field length. Now, is there any catch or is it safe to do or any condition for this like limited to data type. Does anyone have experience doing this. Thanks        

---

Never miss a thing. Make Yahoo your homepage.
--

http://www.freelists.org/webpage/oracle-l Received on Sun Feb 10 2008 - 16:35:49 CST