Look in $ORACLE_HOME/rdbms/admin/dbmsstdx.sql
There are numerous functions which can be called from
DDL triggers to return useful information. One you will
want is: dictionary_obj_name
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
S.A. wrote in message <9rbubd$i1e13_at_kcweb01.netnews.att.com>...
>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 - 11:22:47 CDT
