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

On Mon, 07 Mar 2005 15:16:57 -0800, 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!

You will not be able to add a trigger to the view anyway, as it's owned by SYS. Even if you could, I hope you realize that doing so would null your support (assuming you bother with support).

One option is a DBMS_JOB that will do a periodic comparison to snapshots. Tedious? Of course - otherwise people would not be able to charge for change management methodolgies & software ... ooops, sorry, I won't go there.

FGB Received on Mon Mar 07 2005 - 17:55:38 CST