Re: Find who deleted records from a table - Help please
From: Mariusz Piechna <mpiechna1_at_gmail.com>
Date: Wed, 11 Jul 2018 21:50:55 +0200
Message-ID: <CADat7M=sq+0d=B35-ohoTe006zZDmFmNnnvZEUCd4TH1Qx4Kcw_at_mail.gmail.com>
Date: Wed, 11 Jul 2018 21:50:55 +0200
Message-ID: <CADat7M=sq+0d=B35-ohoTe006zZDmFmNnnvZEUCd4TH1Qx4Kcw_at_mail.gmail.com>
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_at_gmail.com> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 11 2018 - 21:50:55 CEST