Note
This view is available starting with V3.1.2.
Purpose
This view displays the dependencies between all objects in the database.
Applicability
This view is available only in Oracle mode.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The name of the owner of the dependent object. |
| NAME | VARCHAR2(128) | NO | The name of the dependent object. |
| TYPE | VARCHAR2(23) | NO | The type of the dependent object. |
| REFERENCED_OWNER | VARCHAR2(128) | NO | The name of the owner of the referenced object. |
| REFERENCED_NAME | VARCHAR2(128) | NO | The name of the referenced object. |
| REFERENCED_TYPE | VARCHAR2(18) | NO | The type of the referenced object. |
| REFERENCED_LINK_NAME | VARCHAR2(128) | NO | The name of the referenced object's DBLink. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | Indicates whether the dependency is a strong dependency or another type of dependency. |
Sample query
Query the dependencies between all objects in the database.
obclient [SYS]> SELECT * FROM SYS.ALL_DEPENDENCIES;
The query result is as follows:
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
| OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE | REFERENCED_LINK_NAME | DEPENDENCY_TYPE |
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
| SYS | VERIFY_FUNCTION | FUNCTION | SYS | COMPLEXITY_CHECK | FUNCTION | NULL | HARD |
| __public | VERIFY_FUNCTION | SYNONYM | SYS | VERIFY_FUNCTION | FUNCTION | NULL | HARD |
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
2 rows in set