CODEWITHSUNDEEP
oracle-database
avenirit12
avenirit12

Reputation: 243

Oracle Table Logging

I have a scenario where I would like to know about a particular table in a database as what applications are accessing it to identify the dependency of applications (more than one java project) on this particular table.

Is there a way I can turn on a log feature on a particular table in the database to get more information about that table only, The information I am looking for is dependency on this table (as what applications use this table in their code)

Upvotes: 0

Views: 104

Answers (1)

Pravin Satav
Pravin Satav

Reputation: 702

To find out Oracle dependencies you can leverage metadata tables.

  • To find out table dependencies - dba_dependencies
  • To find foreign key constraints - dba_constraints

Upvotes: 1

Related Questions