RE: How to find the view names where a particular table is used

Try querying dba_dependencies... select referenced_name,referenced_type from dba_dependencies where name = 'your view name'; -- Janardhana Babu -Original Message- Sent: Friday, March 15, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way of finding out what

RE: How to find the view names where a particular table is used

select name from user_dependencies where type = 'VIEW' and referenced_name = 'GIVEN_TABLE_NAME'; - Kirti -Original Message- Sent: Friday, March 15, 2002 4:34 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way of finding out what views are using a given table? Shashank