Re: deleted objects; no auditing

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.