hi every one,
my question is how do you find out about a particular table's transaction history
ie. every insert, update, delete.... statetments
my problem is that i need those information based on a already existing database
so, the audit trail method is useless because they didn't set the option when performing the transactions.
how do i retrieve those data now?
Have your DBA turn on auditing for this user for all DML stmts.
Hi Halo, I don't think it's turn on. Is this mean that I couldn't do it at all if it is not turned on?
Thank you for your reply.
set AUDIT_TRAIL=DB in ur init.ora file and then set the Auditing commands and check the history in the V$AUD.
hope this will solve ur problem
It is perfect situation for writing database trigger to audit the specific table's DDL transaction.