在Oracle中如何跟踪依赖于表的表/视图/等 [英] How to track which tables/views/etc depends from a table, in Oracle

问题描述

如何知道哪些对象(表/视图/等)使用某个表?

How to know which objects (tables/views/etc) uses a certain table?

我必须替换我的桌子PRICE. 那么，有没有类似的东西?

I have to replace my table PRICE. So, is there something like?

select system.dependencies from PRICE

推荐答案

SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'

这篇关于在Oracle中如何跟踪依赖于表的表/视图/等的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！