Home » Other » General » How do we verify who has deleted rows from a table ? (10.2.0)
icon1.gif  How do we verify who has deleted rows from a table ? [message #468258] Thu, 29 July 2010 06:11 Go to next message
OraclePTDBA
Messages: 5
Registered: July 2010
Location: Hyderabad
Junior Member
Hi
From an user -

"We are not getting records for below query
SELECT *
FROM gets_rmd_flt_strategy
WHERE flt_strat2flt_code IN('17903','17929','18517','26846','37700','45100','45101','45102','45103')"
It seems someone has deleted theses records from gets_rmd_flt_strategy table. Could you please let us know why these records deleted and by whom?"


How do we verify who has deleted rows from a table ?

Regards
Re: How do we verify who has deleted rows from a table ? [message #468261 is a reply to message #468258] Thu, 29 July 2010 06:43 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Log mining
Re: How do we verify who has deleted rows from a table ? [message #468263 is a reply to message #468261] Thu, 29 July 2010 07:03 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Or auditing if you've got it switched on which you probably haven't.
If you're going to get questions like this a lot I suggest you switch it on.
Re: How do we verify who has deleted rows from a table ? [message #468268 is a reply to message #468263] Thu, 29 July 2010 07:42 Go to previous messageGo to next message
Michel Cadot
Messages: 57612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and carefully choose the forum you choose to post.
This has nothing to do with a performances question.
If you don't know, the best thing you have to do is to post it in General forum, do not randomly pick up one.

Regards
Michel
Re: How do we verify who has deleted rows from a table ? [message #468465 is a reply to message #468268] Fri, 30 July 2010 02:32 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
One Thread is Already Going on in Server Administration For AUDIT
Previous Topic: oracle development
Next Topic: ORA -24247
Goto Forum:
  


Current Time: Sat Apr 19 08:57:26 CDT 2014

Total time taken to generate the page: 0.14934 seconds