Re: ALTER MLOG$ TABLE ADD COLUMN

Deepender,
Wow, that is a very brave move. I didn't think Oracle would let you do it in the first place!

Are your snapshots still working? Is the new column in MLOG$ being populated? How are you going to handle the snapshot at the slave end? Do another alter table add column?

Going by the Oracle manuals the correct way would be to drop the snapshot and snapshot log, add the columns to the master the slave and recreate the snapshot logs and snapshot.

HTH, Leng.  

• From: "GUPTA, DEEPENDER" <DGUPTA_at_xxxxxxxxxxx>
• To: "'ORACLE-L'" <oracle-l_at_xxxxxxxxxxxxx>
• Date: Wed, 16 Mar 2005 09:49:14 -0600

Few days back one of my team member added few columns in the master table and
also added these columns directly to MLOG$ table (Not through the SNAPSHOT LOG
on the master table). Now in the TOAD I can not see the additional columns in
the SNAPSHOT LOG script.
Does it make any difference or have any adverse effect on replication?  

Thanks    

Leng Kaing

Hansen Technologies

2 Frederick St; Doncaster VIC 3108  

Tel: +61-3-9840-3832      

--
http://www.freelists.org/webpage/oracle-l