-
logs
Hi All,
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
Thanks
-K
-
LogMiner or enable auditing
F.
-
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
Brisbane Australia
-
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.
Agasimani
OCP(10g/9i/8i/8)
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
|