Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Need to write trigger for "adding a new table"
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 Received on Mon Mar 07 2005 - 17:16:57 CST
![]() |
![]() |