| 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 #392303 is a reply to message #392168] |
Tue, 17 March 2009 06:25  |
|
>>IN replication management using a materialized view.... how do I know
This question NOT clear to me; Explain me more details.
>>if my site is in synch with master site ?
Your asking to US or Your using Synch based replication??
1/ What's your database version (4 digit)
2/ Are you using Advanced Replication Or Basic Replication??
>>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..
If you want you can analyze using DBA_MVIEWS
|
|
|
| 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?
|
|
|
|
] 
Members
Search
Help
Register
Login
Home
