Check if this DB object is used in Oracle?

Question

Hi, does anyone know how to check if a given DB object (Table / View / SP / Function) is used inside Oracle.

For example, to check if table "A" is used in any SP / Function or View definitions. I am trying to clear unused objects in a database.

I tried query selection * from all_source. WHERE TEXT, for example, "% A%" (A is the name of the table). Is it possible to assume that it is not used if it does not return any results?

Answer 1

From this ASKTOM question :

, 3 , .

- , , , (: ), .

USER_DEPENDENCIES, , sql

ALL_SOURCE, , .