0

I have a certain requirement where in I have been given a table name say ABC, i want to find out which all procedures,packages,mv's,functions refer to that particular table 'ABC' or do a insert or update on that table. Is there any way or query to find this.

Since I cannot look up the code of every object in the schema, I am searching for another way.

J. Chomel
  • 8,193
  • 15
  • 41
  • 69
MajoR
  • 121
  • 2
  • 11

1 Answers1

0

You may use Oracle System view dba_dependencies (check with your dba if you don't have access to this view).

select * 
  from dba_dependencies 
 where referenced_name='ABC' 
   and referenced_type='TABLE';

Beware, your objects may also use synonyms. So a second list could come with:

select * 
  from dba_dependencies 
 where referenced_name='ABC' 
   and referenced_type='SYNONYM';
J. Chomel
  • 8,193
  • 15
  • 41
  • 69