Re: Find who deleted records from a table - Help please
Date: Wed, 11 Jul 2018 15:01:19 -0400
Message-ID: <CAPptggUbdcyForA=qfUWuDfNdr6TwM=PDjo0wK0EcqdmRyGtSQ_at_mail.gmail.com>
Query might still be in the shared pool. Undo segments might not have yet been overwritten. Logminer might not be the only option.
On Wed, Jul 11, 2018, 2:01 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
> In addition to LogMiner, which is a pain in the neck or lower, does your
> application have logging enabled? Maybe application logs will reveal
> something?
>
>
> On 07/11/2018 01:33 PM, Manjula Krishnan wrote:
> > 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
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 11 2018 - 21:01:19 CEST