Oracle 11g - Best Possibilities
Problem Description:
One of our web based application is based on Oracle 11g. Since this application is not capable of capturing audit-trail information we are planning to have DB triggers for capturing all actions like inserts, updates or deletes on these tables to populate custom history tables for audit-trail purpose. Is this a proper way to do it in Oracle 11g? Or do we have other options in 11g? Also if we have DB triggers applied can we directly populate history tables or we need to have some temp tables to have actions recorded first for particular records and update history tables