Note
This view is introduced in V3.1.2.
Purpose
This view shows the dependency relationships between all objects in the database.
Applicability
This view applies only to OceanBase Database 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 Dblink of the referenced object. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | The type of dependency, such as strong dependency or other dependency. |
Sample query
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