Re: Get Trigger Name with Column Name
You mean to say that I must first get a list of all the triggers available in the database then read through their definition to find if the column is being used in that trigger, if so then add that trigger's name in the drop script so when the script is executed, the trigger also gets deleted.
Well I think this whole pratice is not feasible as there may be 1000s of triggers in the system and for each column I would need to search the definition of these 1000s of triggers.So I am not comfirtable with that, as that is going to take a long time to complete the execution.
There should be some other way around, some way to identify the triggers which access a certain column.
Subject
Written By
Posted
February 14, 2011 08:22AM
February 16, 2011 12:27AM
Re: Get Trigger Name with Column Name
February 21, 2011 03:57AM
February 23, 2011 02:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.