wiki:MVRefresh

Materialized Views Replication - on Oracle on beta.klp.org.in

More on Materialized Views -

http://download.oracle.com/docs/cd/B19306_01/server.102/b14226/repmview.htm#REPLN003

http://www.oracle-base.com/articles/8i/MaterializedViewReplication.php

Materialized view replication between the Users on Oracle beta.klp.org.in- AKSHARAEMSMIGRATED and REPL_AKSEMS has been set up through ~oracle/replication/mvrefresh.sh

It makes use of ~oracle/replication/mrg.sql and sp_rocnt on REPL_AKSEMS to generate Materialized views and and replicate changes from SOURCE: Aksharaemsmigrated to DESTINATION: Repl_aksems

Daily logs of the replication process are maintained in the ~oracle/replication folder.

Notes:

Post migration of Aksharaemsmigrated from e-gov db server to beta.klp.org.in, the internal database link DBA_DB_LINK to db102 in repl_ aksems that was previously used has been dropped.

and mrg.sql has dropped the connection references to the e-gov db server

Last modified 7 years ago Last modified on 01/04/11 17:19:21