Before I update a base table, I need to investigate which other objects are going to be affected by this change.....i.e. I need to find out all the objects that are using this table. This could be recursive..in other words the object using this table could be used by other objects. I need to get down to the bottom of the tree.
Could someone pleae suggest the best way of doing so. A readymade hierarchical query would be much appreciated.
"The ODA tool has been written to analyze database dependencies between database objects such as procedures, tables, views etc. The tool can also be used to analyze database dependencies between objects in Forms/Report PL/SQL code and block properties and the database objects dependencies also. The ODA find object usage in the flat files(Unix scripts,C,XML) ,Informatica workflows and Word files"