Is there a way to check when a particular table was last modified and by which user.
I had entered some data in a table and that column now is empty and I need to find out the cause so please let me know if there is a way to check what time the table was edited.
Any help is highly appreciated
LogMiner or enable auditing
Also an UPDATE,INSERT,DELETE trigger on the table, that captures the modified data and the Oracle user, and inserts it into an "AUDIT" table.
OCP 8i, 9i DBA
Now since you want to see what already has happened, you can look into Logminer (if you have 8i onwards database).
To avoid such problems in future, you can use object level triggers, like DELETE trigger.
Click Here to Expand Forum to Full Width