Re: deleted objects; no auditing

From: Cosmin Ioan <cosmin_ioan_at_my-deja.com>
Date: Wed, 04 Oct 2000 17:43:31 GMT
Message-ID: <8rfq80$9g9$1@nnrp1.deja.com>

thanks Howard :-)

In article <39d6d00c_at_news.iprimus.com.au>,   "Howard J. Rogers" <howardjr_at_www.com> wrote:
> If you have 8i, you can use Log Miner to analyse redo logs for
 deletes on
> the UET$ table (used extents, assuming dictionary managed
 tablespaces). Log
> Miner can be applied to redo logs from Oracle 8.0.x -but if you've
 only got
> version 7, forget it.
>
> The v$logmnr_contents view that you get when analysing logs will show
 you
> the User that did the object drops, too. Which is handy when it
 comes time
> to fling recriminations around!
>
> Regards
> HJR
> --
> ----------------------------------------------------------------------

---

> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources:

 http://www.geocities.com/howardjr2000
> ----------------------------------------------------------------------

---

>
> "Cosmin Ioan" <cosmin_ioan_at_my-deja.com> wrote in message
> news:8qnpp0$l1i$1_at_nnrp1.deja.com...
> > hello all,
> >
> > qq: in the absence of having turned on the auditing features of
> > Oracle, is there any way to find out what objects (table, procs,
> > packages, etc) have been deleted!?
> >
> > thanks,
> >
> > Cosmin
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 04 2000 - 12:43:31 CDT