Thank you. It was very helpful.
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:1004113670.11144.0.nnrp-13.9e984b29_at_news.demon.co.uk...
>
> 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 - 12:31:39 CDT
