Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Need to write trigger for "adding a new table"

Need to write trigger for "adding a new table"

From: <deanbrown3d_at_yahoo.com>
Date: 7 Mar 2005 15:16:57 -0800
Message-ID: <1110237417.408305.251240@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US