Topera
Topera

Reputation: 12389

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?

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

select system.dependencies from PRICE

Upvotes: 4

Views: 24531

Answers (1)

Adam Butler
Adam Butler

Reputation: 3037

SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'

Upvotes: 8

Related Questions