Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: (invalid) dependencies management
Ioan,
I think that the *_DEPENDENCIES views may be what you're looking for.
Also note that 11g changes some of this as it does something termed "fine-grained dependency checking" meaning that it won't just be object-level invalidation. It's supposed to be smarter than that and only invalidate the dependent objects if there's a need to do so. For example, adding a column to a table shouldn't invalidate dependent objects unless they did SELECT * FROM object;.
I think you're on the right track with the CONNECT BY query, but I don't have the syntax handy. I'd definitely use the *_DEPENDENCIES view for that query.
Dan
hi all,
I have a (two-fold) question about object dependencies when a particular object is recompiled:
Could someone help w/ the latter strategy?
thx anticipatedly,
Cos
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 11 2007 - 13:36:45 CDT
![]() |
![]() |