Home » Server Options » Streams & AQ » Is Stream Replication is good for dynamic databases. (Oracle 10g)
Is Stream Replication is good for dynamic databases. [message #426017] Tue, 13 October 2009 14:15
Messages: 7
Registered: October 2009
Junior Member
We have a master database which is updated daily using batch processes.
We have a application specific DB which is exactly same as above master DB + some application specific tables.

We want to update this application DB from the master DB once a day, only for the updations that happened on that master DB.
The tables have about 35 M records. (atleast 6-8 tables)

The application DB has various Materialized Views those needs to be refreshed immideately after the DB refresh from main DB.
Our Cache needs to be refreshed with about 35 M rows, if there are any changes to the application DB.

So considering these scenerios, what is the best way for us to keep the above two DBs in Sync.?

To summarize -> Our requirement is to keep master DB and application DB in sync and also update the Materialized Views, Cache etc immideately after the refresh, and many table have about 35 M records and Materialized View refresh itslef takes about 5-6 hrs.

Pleae advise different ways.

Thanks in advance.
Previous Topic: AQ commit time ordering queue
Next Topic: Oracls stream and sql server replication
Goto Forum:

Current Time: Tue Aug 03 16:04:58 CDT 2021