Re: Lost tables

From: DanHW <danhw_at_aol.com>
Date: 21 Jun 1998 02:57:30 GMT
Message-ID: <1998062102573000.WAA24404_at_ladder01.news.aol.com>


If >>Is there any way in Oracle to trace back deletion/truncation of schema
>>objects (Oracle Tables)
>>Several tables are missing from a production database and we suspect this
>>was done by a disgruntled employee
>>Any information will be appreciated
>>thanks
>>Peter Townsed
>>
>>

You MIGHT be able to locate other objects that depend on these tables (views, procedures, etc). Look at the column 'LAST_DDL_...' in USER_OBJECTS for these objects. This MIGHT tell something. In the future, you can enable auditing. This can be set up to be very selective, so you can minimize any performance impacts.

Dan Hekimian-Williams Received on Sun Jun 21 1998 - 04:57:30 CEST

Original text of this message