Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: (invalid) dependencies management
select * from dba_dependencies
start with referenced_name=:tabname and referenced_owner=:owner and referenced_type=:objtype
connect by prior name = referenced_name and prior owner=referenced_owner and prior type=referenced_type
I think you can use this. This is something I use from time to time. I did not test it thoroughly.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cosmin Ioan
Sent: Wednesday, July 11, 2007 8:07 PM
To: oracle-l_at_freelists.org
Subject: (invalid) dependencies management
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-lReceived on Thu Jul 12 2007 - 03:38:43 CDT
![]() |
![]() |