Home » Server Options » Replication » Replication in Oracle 10g (10g Rel 2)
Replication in Oracle 10g [message #327438] Mon, 16 June 2008 07:19 Go to next message
Messages: 84
Registered: March 2005
Hi All,
We are using Oracle 10g rel 2.
The replication is setup on 1 server which is in City A, and the snapshot server is in City B.

City A .
Create materialized view log on table-a
with primary key
including new values.

City B database.
Create user test_rep identified by test
grant connect, resource, create any materialized view , table, view , procedure to test_rep.

Create materialized view city-A_db_MV
refresh fast
select * from cityA.Tablea@city-Adb

When i select from city-A_db_MV, it showed the complete table-A of city-A database.

Now if we make any changes to City-A table at the Master site, will it be propagated automatically to the MV site.

I guess we need to create jobs to push / or refresh fast .. isnt it.
But exactly how to do it is a question.

Secondly if we make a replication group at Master site at city-A db,
how do we refresh that Group and how to monitor whether it is refreshing on time or not? do we need to see the jobs every now and then.

but still a lot of questions unanswered, even though i had read the documents earlier.

1-The MView was created without identifying that after what interval it will be fast refreshed.
2- How to Manually refresh it. Does it support On Commit, I think it is not.

3- Where should be we make a group and then add the table to that group and refresh that group.

Should this group belongs to the Master Site or to MV site?
Re: Replication in Oracle 10g [message #328660 is a reply to message #327438] Sat, 21 June 2008 04:57 Go to previous message
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Please read below link before posting any query's


1. http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/toc.htm

2. http://babudba.blogspot.com/search/label/Advanced%20Replication


[Updated on: Sat, 21 June 2008 05:00]

Report message to a moderator

Previous Topic: wrong number or types of arguments in call to 'VERIFY_LOG'
Next Topic: Fast Refresh of materialized view too slow
Goto Forum:

Current Time: Sun Oct 23 09:42:06 CDT 2016

Total time taken to generate the page: 0.12610 seconds