Home » Server Options » Replication » materialized view question.
materialized view question. [message #392168] Mon, 16 March 2009 13:04 Go to next message
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 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>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 Go to previous messageGo to next message
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?

Re: materialized view question. [message #392418 is a reply to message #392342] Tue, 17 March 2009 22:28 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
1/ What's your database version (4 digit)

2/ Are you using Advanced Replication Or Basic Replication??


Babu
Previous Topic: Materialized VIEW flush scenario
Next Topic: Setup a refresh group for nested materialized views
Goto Forum:
  


Current Time: Thu Mar 28 18:42:18 CDT 2024