|
|
|
Re: Is there a way to tell who deleted a sales order [message #382384 is a reply to message #382298] |
Thu, 22 January 2009 01:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Perhaps you might want to check Log Miner:Quote: | All changes made to user data or to the database dictionary are recorded in the Oracle redo log files (LF: you, of course, have redo log files) so that database recovery operations can be performed.
Because LogMiner provides a well-defined, easy-to-use, and comprehensive relational interface to redo log files, it can be used as a powerful data audit tool, as well as a tool for sophisticated data analysis.
|
By the way, if there are no that many employees, perhaps someone will "confess" that he/she had done that (so that you wouldn't have to investigate it in a more difficult way).
|
|
|