Purpose
The USER_DEPENDENCIES view displays the dependencies among objects in the schema of 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
ALL_DEPENDENCIESDBA_DEPENDENCIES
Fields
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| 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 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. |
| SCHEMAID | NUMBER | NO | The schema ID of the current user. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | Indicates whether the dependency is a strong dependency or another type of dependency. |