Re: Trigger on drop of a specific table

Hi

have a look at the "event attribute functions" provided to use in DDL triggers, the ones you need are

dictionary_obj_type
dictionary_obj_name
dictionary_obj_owner

you will find descriptions in the documentation, search for "working with system events".

HTH Pete Finnigan
www.pentest-limited.com

In article <9rbubd$i1e13_at_kcweb01.netnews.att.com>, S.A. <adenwalaNO_SPAM_at_att.com> writes
>Friends,
>
>I am trying to write a trigger that would fire when a specific table in a
>schema is dropped.
>The trigger -
>CREATE or REPLACE TRIGGER <trigger_name> AFTER DROP ON <username>.schema
>fires when ANY object is dropped in the schema. I have tried to write a
>PL/SQL block within the trigger that would check the non-existence of the
>specific table and then carry out the intended actions, but that too does
>not work, since the trigger is fired as the last action before the table
>actually drops.
>
>Any help will be appreciated.
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com