| How to audit dml operations to tables which include old value ,new value without using dml triggers [message #61019] |
Sun, 21 March 2004 00:16  |
sohel
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
Hello........
Someone please help me. Is there any way for logging changes made to tables including old value and new value without using the pre post insert,update or delete trigger? I know something about built in audit feature but not clear about that. There is a command - 'Audit insert,update,delete on scott.emp ' which activate audit feature for auditing insert,update or delete operation on emp table in scott schema. But I am not sure how much information about an dml operation I can get with this audit feature activated and where to look for the audited informations from this utility.I mean specificly ,in which dictionary view i should look for the audited informations. Will I get the old and new values for an updation in the dictionary view ?
I will be really grateful for any solution. Many thanks in advance.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
