Home Forums SQL Server 2008 Working with Oracle Materialized View Logs on Log shipped secondary server database RE: Materialized View Logs on Log shipped secondary server database

  • sqlbi.vvamsi (11/30/2012)


    Based on what I know, Materialized View Log is a master table that can capture deletes/inserts/updates just like CDC tables.

    You are correct, Materialized Views are an Oracle concept.

    Having said that and just to clarify your statement above...

    "Master table" is the base table (or tables) used to create a Materialized View.

    "Materialized view" is a snapshot-in-time copy of a base table, or a subset of it.

    "Materialized view log" is a log on the base table used make materialized view refresh quicker.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.