Home » SQL & PL/SQL » SQL & PL/SQL » Replication
Replication [message #206683] Fri, 01 December 2006 01:34 Go to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member


There are two systems in my organization. We will say one as server and other one as branch. Server is replicating data from branch. at branch table having a numeric field with length 4 .Now filed length will be change from 4 to 11.

Replication is set on FAST mode.
In this scenario I have few quires
1) If branch table will be updated (length will be 11 from 4) then snap shot logs will be dropped or not?
2) Will there be need to recreate the snapshot at server or it will be automatically updated in next replication.

please reply soon as it is bery urgent

thanks in advance!!!
Re: Replication [message #206711 is a reply to message #206683] Fri, 01 December 2006 03:41 Go to previous messageGo to next message
prasanna_anbu
Messages: 34
Registered: November 2006
Location: india
Member
U must recreate the snap shot because the table structure.
Re: Replication [message #206791 is a reply to message #206711] Fri, 01 December 2006 08:41 Go to previous message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

I wanted to understand difference between writable materialized view query and read only materialized view query,
Previous Topic: Extract Year and Month
Next Topic: Create Oracle 9i Documentation
Goto Forum:
  


Current Time: Fri Dec 09 09:31:58 CST 2016

Total time taken to generate the page: 0.13088 seconds