1 2 Previous Next 15 Replies Latest reply on Aug 30, 2013 9:05 AM by Christian

    Create Compare Script


      Hey, I am not really good in scripting, perhaps you guys can help real quick.


      I like to compare  numbers in a table in two databases ( mirrored by GoldenGate).

      If the source number of this column is higher (+5) than the destination database I like to send a snmp trap to my monitoring.


      How would you do this ? Creating a public database link on the source site, a query the same table and compare the values ?


      select id from table_a;  eg (result 99)

      select id from table_a@publink; eg  (result 98)


      How to compare ?



        1 2 Previous Next