Re: Find who deleted records from a table - Help please

  • From: Mariusz Piechna <mpiechna1@xxxxxxxxx>
  • To: oradba.la@xxxxxxxxx
  • Date: Wed, 11 Jul 2018 21:50:55 +0200

Hi,
dba_hist_sqltext view will help you to find necessary DELETE statement and
dba_hist_active_sess_history view you find history details of session by
e.g. sql_id.

Cheers!

śr., 11 lip 2018, 19:34 użytkownik Manjula Krishnan <oradba.la@xxxxxxxxx>
napisał:

Hi:

We dont have auditing turned on. DB is in archive log mode. Yesterday
someone/something deleted 12 records from a table and I need to find who.

Can someone help me please?

Thanks,

Manjula

Other related posts: