I have been using toad to view dependencies of tables / queries,
however, the toad feature "Deps (Uses)" only shows the queries / tables
in the FROM clause of the outermost block of the sql statement, leaving
out any queries / tables in the FROM clause of nested queries. I have
inherited a monstrous DB w/ many complex nested queries that requires
some structural changes, so it is pertinent that I can assess the true
dependencies of the views (not just those in the outermost sql block).
Does anyone know of a way to ascertain such information?



Aaron Olmstead

Senior Data Analyst

Harbour and Associates, Inc.

www.harbourinc.com <http://www.harbourinc.com/>





Oracle LazyDBA home page