Updating Master Site from Materialized View Sites
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Updating Master Site from Materialized View Sites

  1. #1
    Join Date
    May 2003
    Posts
    32

    Updating Master Site from Materialized View Sites

    Hi All!
    This is a n interesting scenrio,

    I have a Master Site and a Updatable Materialized View Site.
    I m posting trasaction on the Uptable Materialized View Site. But i dont want to the push the transactions from here to the Master Site.
    To do that i executed the procedure DBMS_DEFER_SYS.SET_DISABLED TO true. But now i want Master Site to PULL the updates from the Updatable Materialized View Site.
    The scenerio is a bit complex but an interesting one..
    What i have to implement at the Master Site to get the Updates from the Updatable Materialized View Site.

    Suggestions.

    RAFF

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Not so intresting... though, make the table at your so called "Updatable Materialized View Site" as the master table and make the slave table at the Master site. Simple wasn't that.

    That way your Master Site can act as Materialized View Site for your Updatable Materialized View Site for that particular table.

    You can have a Master Site (which can be also a Materialized View Site) and a Updatable materialized view site (which can also be a Master Site)

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width