mv replication

Posted on 2012-09-14
Last Modified: 2012-09-18
could you give some idea about mv replication...
Question by:tomvv
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    The online docs are the best place to start:

    Do you have a specific question on mv replication?
    LVL 3

    Accepted Solution

    MV replication is an option to replicate data between one master site and any number of Materialized Views (MV). In MV replication, you can have one master site and any number of MV sites. The original tables for replication will be on the master site and the snapshots (MV)  of these tables will be on the MV sites.  You can have read only and update MV replication.
    For the MV replication, you must have the following things.
    I. Master Site
        1. Master Group  
        2. MV logs ( created for the tables in the replication).
        3. Add the tables in update replication to the master group.

    II. MV Site.
         1. Create MV Group.
         2. Create MV based on the tables of the master group
         3. Add the MV to MV group.
         4. Create the refresh group in order to specify the refresh time for data.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now