Use event schedule rather than trigger?
I have been using a TRIGGER to log data from one table to another. The TRIGGER is called on UPDATE. The problem is that I want to limit how often data is logged. This is proving difficult with a TRIGGER (at least for me).
Yesterday I was introduced to the Event Scheduler, which I am now using to dump the log tables out to csv files and empty the tables once a day.
Now I am wondering if I would be better off just using the event scheduler to do logging too then I could just specify a time period for data to logged?
What are the pros vs cons here?
Subject
Views
Written By
Posted
Use event schedule rather than trigger?
2604
March 09, 2012 02:16AM
1031
March 12, 2012 02:30AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.