data dictionary for DML performed
which data dictionary will give information about what DML operations are performed on a particular table.
for Ex: if a user has inserted or updated a record in a table, i want to see the information about the DML performed.
Thanx in advance
you cannot, those things are not recorded in any table, if you really want to see the DML statements you have to mine the logs using logminer
my requirement was that i wanted to see what DML operations are performed on the Table and not the DML statement. like when last insertion was performed , when last updation was performed on the table. basically Audit sort of things
Then either use database audit or write your own triggers on those tables
for auditing use foll
If you go for triggers you should know your business requirements as trigger will fire for every single DML and may degrade your performance. Audit also makes performance bit slower.
Last edited by paragp1981; 12-20-2007 at 06:59 AM.
Click Here to Expand Forum to Full Width