| materialized view question. [message #392168] |
Mon, 16 March 2009 13:04  |
rajesh_tns
Messages: 6
Registered: February 2009
|
Junior Member |
|
|
HI
IN replication management using a materialized view.... how do I know
if my site is in synch with master site ?
Ex:
Iam doing a fast refresh
when a master site is refreshed ..i need my local site to record those changes...
how do i find that the rows are affected..
i donot want to compare manually..
is there any mechanism?
regards
raj
|
|
|
|
|
|
| Re: materialized view question. [message #392342 is a reply to message #392303] |
Tue, 17 March 2009 09:54  |
rajesh_tns
Messages: 6
Registered: February 2009
|
Junior Member |
|
|
HI Babu
Scenario is like this
I Have 4 different oracle databases A B C and D
i have a matview on A (master):
B,C,D holds the replica of A.
Now when ever the matview in A refreshes.. then we need to refresh B, C and D too right?
Let us suppose A,B,C,D all holds 500 records.
Now, some 100 records got updated in A and 100 new records are added. (Total changes=200)
Now i have to make sure that 100 records are updated and 100 new records are inserted in B,C,D as well ... right?
now my question is I should know just by looking at B,C,or D that these are the 200 records that are updated/inserted today.
Am I clear now?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
