-
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.
-
hi toad
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
pras
-
It is perfect situation for writing database trigger to audit the specific table's DDL transaction.
Take care
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|