Materialized Views Replication - on Oracle on

More on Materialized Views -

Materialized view replication between the Users on Oracle AKSHARAEMSMIGRATED and REPL_AKSEMS has been set up through ~oracle/replication/

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.


Post migration of Aksharaemsmigrated from e-gov db server to, 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