<< Click to Display Table of Contents >>

Object Dependencies

Top Previous Next

The Oracle database contains various kinds of database objects, where objects are by definition dependent on the status of other object(s). If an object with dependencies changes or becomes invalid, all other objects depending on the object also become invalid.

The Dependencies tab shows the dependencies between the currently selected table or view and other database objects, in both directions, as shown in the illustration below.

Clicking on the "Referenced by" plus sign produces a list of all the objects that refer to the selected table—in this case, a procedure and some triggers.

"References" shows objects that are referred to in the table's DDL, such as the user-defined type of one of the table's columns.