Table Dependencies Objects

Onur ARDAHANLI

5 months ago

In today’s article, we will discuss how to check the objects that are dependent on the table and how to find the dependent objects.

When we delete a table, the objects connected to that table are checked as follows, so that the objects connected to that table are not damaged.

SQL> select * from DBA_DEPENDENCIES WHERE REFERENCED_NAME='CHANNEL_STATS';

1	SQL> select * from DBA_DEPENDENCIES WHERE REFERENCED_NAME='CHANNEL_STATS';

We can find objects that depend on a table as follows.

SQL> SELECT * FROM DBA_DEPENDENCIES D WHERE (D.REFERENCED_NAME, D.REFERENCED_TYPE) 
IN (SELECT NAME, TYPE FROM DBA_DEPENDENCIES D1 WHERE D1.REFERENCED_NAME IN ('ACCOUNT'));

1 2	SQL> SELECT * FROM DBA_DEPENDENCIES D WHERE (D.REFERENCED_NAME, D.REFERENCED_TYPE) IN (SELECT NAME, TYPE FROM DBA_DEPENDENCIES D1 WHERE D1.REFERENCED_NAME IN ('ACCOUNT'));