AWS Database Blog

Suresh Konappanavar

Author: Suresh Konappanavar

Analyze Amazon RDS for Oracle database object dependencies

In this post, we show you an analysis tool which serves as a starting point to your database analysis journey by highlighting specific interdependencies between database objects: object dependencies, object constraints, and trigger references. Through a combination of SQL queries on the source Oracle database dictionary and Excel filters, the solution in this post can capture interdependent database objects for a target schema and generate a visual dependency diagram.