You must Sign In to post a response.
  • Category: General

    Oracle data change notification

    Hello Everyone,

    I have a requirement to watch oracle database continuously and get notification as soon as changes happens in the database , Collect changed data ,create excel/cvs/xml file and dump in some folder. These files will be moved to other server using SFTP.
    Some of these data will be converted into jason format and sent to cloud in the message format.


    I am very new to oracle .
    I am not sure which feature of oracle is best fit for above situation.

    I am thinking "continues query change notification" will help but not sure .

    Please suggest.
  • #757789
    Hello Mahima,

    Refer the link for Oracle database change notifications for Admins, Users.
    How to register it and How to deregister it with examples.

    http://docs.oracle.com/cd/B19306_01/appdev.102/b14251/adfns_dcn.htm

    Hope it will help you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"

  • #757790
    Thanks Nirav .
    Is there any other method to get notification

  • #757793
    Recently I have implemented oracle database change notification in my asp.net application so whenever the data in the specified table is updated, the asp.net application is notified and it takes the required action by updating the cached database data and update the ui with this new data.
    Miss. Jain
    Microsoft Certified Technology Specialist in .Net

  • #757798
    Thanks Priya.

    There will be more than 500 users who hits the oracle database frequently . As soon as data changes I need to pull it and send to azure messaging queue.

    Do you thing database change notification or Query result change notification will help?

    What will be the load on the server ?

    Thank you in advance.

  • #757825
    I think you can use a service for this with a single Service You can update all the Users with that service on a regular time interval basis....

    or if you Just want to know whether the Table has a new entry Make One Column New Modified with Datetime...

    SRI RAMA PHANI BHUSHAN KAMBHAMPATI

  • #757827
    Hi Mahima,

    You can Use Msmq for this whenever a row in a table gets Updated sent to the Msmq with record added date and time or even you can use flat files and xml files too ....
    read the Msmq or read the flat file or xml files for every user in your code and check whether the table has been Updated

    For Msmq read my articles....

    This is Theoretical Explanation

    http://www.dotnetspider.com/resources/44821-Microsoft-Message-Queuing-Aspnet.aspx

    and its a Practical Explanation

    http://www.dotnetspider.com/resources/45339-Monitoring-services-Remotely-your-computer.aspx.

    SRI RAMA PHANI BHUSHAN KAMBHAMPATI


  • Sign In to post your comments