Request for Updated Transaction from remote sites
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Request for Updated Transaction from remote sites

  1. #1
    Join Date
    May 2003
    Posts
    32

    Request for Updated Transaction from remote sites

    Hi All!
    As in a Replication Context. There are two terms mainly used. Publisher and a Subscriber. Publisher where the transactions are generated and Subscribers where the information is replicated. Then we user another Terms liks PUSH AND PULL. Push Transactions mean the updates are send to the subscribers with out any request from them where as in PULL case, a request is made by the subscriber to send thme back the updates.
    We can bulid the PUSH scenerio in Oreacle 9i. but i need to get the information about How we can perform the PULL Scenerio in Oracle 9i.

    Suggesyions?
    RAFF

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    The same way you do a PUSH. Do a PULL from the slave site.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    May 2003
    Location
    Kathmandu, Nepal
    Posts
    16
    I think it is quite simple, you have to setup a read-only snapshot replication, where the "Publisher" is the master site and "Subscriber" is read-only snapshot site. Request for refresh is always made from subscriber side which pulls the changed data from publisher.
    Raj Kishore
    Oracle DBA

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