on 11-25-2015 2:27 AM
Hi Guys,
I know there is a option "Log Data Changes", but when I enabled this option, I see the error "table UJF_DOC for logging is too long(Key<250, data division<16.0000)". It looks like it's not possible to use this option to track the changes this table.
The background information behind this purpose. I suspect someone or some program deleted the entries from this table. As a result, there is something wrong in the application level. However, we don't know when, by who/program. I am not sure if there is any alternative way to find the "ghost". For example, can I use some feature like "Where Used". Then I may find out if this table is used in any program. Then I can check this program and see if there is some code "delete from this table".
Appreciate if you could provide me with some suggestions.
Best regards,
Charlie
Anyone could help? thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If its oracle database and if you set the rention period set for long then you can bring it back. but if you want who has excuted the command then it should be in audit log unless you enabled.
The below link might be helpful.
https://scn.sap.com/blogs/mho/2008/04/23/how-to-get-those-accidentally-deleted-rows-back-on-oracle
Internal Deletion - Find out who deleted data record
Thanks,
Brindavan
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.