How to get the dependencies

There are two ways you may check the dependencies of a table:

1) Using Toad you can see the dependecies of a table

2) Yaping Chen recommends using a procedure with “dbma_utility.GET_DEPENDENCY”

example:

sys@TEST>exec dbms_utility.GET_DEPENDENCY(‘TABLE’,’TEST’,’T1′);
–
DEPENDENCIES ON TEST.T1
——————————————————————
*TABLE TEST.T1()
*   FUNCTION TEST.FUN_T1_01()
*      FUNCTION TEST.FUN_T1_02()

PL/SQL procedure successfully completed.