Database Administration (MOSC)

MOSC Banner

Oracle 11g - Best Possibilities

edited Dec 18, 2008 9:59AM in Database Administration (MOSC) 4 commentsAnswered ✓
 First of all I am not a DBA, but I have a question here regarding Oracle 11g.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center