Oracle Table Logging

Question

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)

Pravin Satav · Accepted Answer · 2015-09-09 07:17:58Z

1

To find out Oracle dependencies you can leverage metadata tables.

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

edited Sep 9, 2015 at 7:17

user330315

answered Sep 9, 2015 at 6:27

Pravin Satav

7025 gold badges18 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

Note that the dba_XXX views are usually not accessible for regular users. You should rather use the ALL_XXX or even USER_XXX views

Collectives™ on Stack Overflow

Oracle Table Logging

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related