Check out Rob van Wijk''s blogpost on this: http://rwijk.blogspot.com/2008/10/dbadependencycolumns.html He describes how you can create a DBA_DEPENDENCY_COLUMNS view yourself. On Wed, Jan 27, 2010 at 2:27 PM, Rumpi Gravenstein <rgravens@xxxxxxxxx>wrote: > All, > > I'm running an 11.1.0.7.0 and looking for the dictionary views that > show the underlying data supporting database object invalidation and > the need to recompile. The behavior in 11g has changed to a finer > grain control. That lower level control is what I am hoping to find > in a dictionary view. > > -- > Rumpi Gravenstein > -- > //www.freelists.org/webpage/oracle-l > > > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.RuleGen.com/pls/apex/f?p=14265:13