Re: how to find out which tables where deleted

From: Michael Paries <paries_at_gmx.net>
Date: 7 Mar 2002 08:05:17 -0800
Message-ID: <aced0257.0203070805.5482f66a@posting.google.com>

Ralph Graulich <ralph_at_grauli.ch> wrote in message news:<ralph-69B47F.14352505032002_at_doorway.ih.reiff.de>...
> Hi Roland,
>
>
> > is there an v$ view or any other resource where i can find out, if a
> > specific table was deleted/dropped by an
> > application ?
>
> You can use the log miner utility to search for tables not being there
> anymore.
>
> A note to your post: A table can't be "deleted". You can either:
>
> a) DROP a table including its content (rows)
> b) DELETE the content of a table resulting in an empty table
> c) TRUNCATE a table (deleting its content, without being able to
> rollback the transaction as no redo information is written)
>
>

> Regards
> ... Ralph ...

Maybe you use an trigger like this:

create trigger trigger_name
on user.schema
after drop
begin

 --...now saving information about dropped object 
 -- dictionary_obj_type
 -- dictionary_obj_name
 -- dictionary_obj_owner

end;

or read in Application Developers Fundamentals Part III, Ch 14 (8i) Received on Thu Mar 07 2002 - 10:05:17 CST