-
data dictionary for DML performed
hi
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
http://download-uk.oracle.com/docs/c...6521/audit.htm
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.
Rgds
Parag
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
|