Re: Need to write trigger for "adding a new table"

deanbrown3d_at_yahoo.com wrote:

> But I can't add a trigger to ALL_TABLES because its a view. What to do?
>
>
> I need to create an update-log table for our database, to write out
> additions of (and changes to) any new tables, so that we can see what
> changes have been made recently. This is to be used in conjunction with
> the change-manager, so please don't go there. I am just not sure how to
> write a trigger for a view. This particular view looks horrendous!
>
> THX!
>
> Dean

You can't in the normal sense in which you are thinking. Changes to tables that would be recorded in ALL_TABLES are DDL and thus are trapped by DDL triggers.

http://www.psoug.org
click on Morgan's Library
click on DDL Trigger

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)