Purpose
The ALL_DEPENDENCIES view displays the dependencies among all the objects accessible to the current user. At present, only dependencies among Procedural Language (PL) objects are displayed.
Applicability
This view applies only to OceanBase Database in Oracle mode.
Related views
DBA_DEPENDENCIESUSER_DEPENDENCIES
Fields
Field |
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 object on which the dependent object is dependent. |
| REFERENCED_NAME | VARCHAR2(128) | NO | The name of the object on which the dependent object is dependent. |
| REFERENCED_TYPE | VARCHAR2(18) | NO | The type of the object on which the dependent object is dependent. |
| REFERENCED_LINK_NAME | VARCHAR2(128) | NO | The name of the Dblink of the object on which the dependent object is dependent. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | The type of the dependency. This field indicates whether the dependency is a strong dependency or another type of dependency. |