I am not familiar with Oracle,but is it possible to add a trigger on the system/catalog table that gets fired when an INSERT happens?
in reply to List DB tables
Upon the table's creation, an entry of that table will be inserted into the catalog and subsequently the trigger will fire and raise a database event which would notify any registered event listeners to perform an action. In this case the listener would be your script,and the action would be to send an email
But I don't know if Oracle supports external database events like Ingres does for example Raise a Database Event