Forum Stats

  • 3,767,857 Users
  • 2,252,726 Discussions
  • 7,874,365 Comments

Discussions

Identify dependencies on tables and columns

user10412263
user10412263 Member Posts: 98 Blue Ribbon

Hi All,

There is a schema A containing many objects which get referred in other schemas.

Need to identify which tables and columns of schema A are getting referred in other schema objects.

Is there any option to achieve this.

Thanks in advance.

Tagged:

Answers

  • Solomon Yakobson
    Solomon Yakobson Member Posts: 18,900 Red Diamond

    Object level dependency can be checked in DBA_DEPENDENCIES data dictionary view. Oracle doesn't track dependencies on column level but for referencial integrity column dependencies can be checked by joining data dictionary view DBA_CONSTRAINTS to data dictionary view DBA_CONS_COLUMNS.

    SY.