Trigger on drop of a specific table

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. Received on Fri Oct 26 2001 - 10:33:40 CDT