Home » RDBMS Server » Server Administration » replication and DDL
replication and DDL [message #53235] Thu, 05 September 2002 11:33 Go to next message
John Bruinsma
Messages: 11
Registered: April 2002
Junior Member
Hi, I hope someone can answer the following question:
At two Orcale 8.1.7 sites, I use "simple" snapshot replication of only 1 master table to a snapshot at the snapshot site. The replication uses fast refresh, so the master table has an associated log.
I want to add columns to the master table. Is that possible, that is, will the snapshot be automatically updated also with the new columns?
Or do I need to setup replication again?
Any tip or comment is highly appreciated.
Thanks !!

Report message to a moderator

Re: replication and DDL [message #54497 is a reply to message #53235] Tue, 19 November 2002 22:33 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No it will not.

Every time you make DDL changes to the master table, you have to re-create the snapshot log for this table. It will not happened automatically.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Tablespace Offline
Next Topic: Oracle settings printout
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:35:04 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.