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 content is only applicable to OceanBase Database Enterprise Edition. OceanBase Database Community Edition only provides the MySQL mode.
Related views
ALL_DEPENDENCIESDBA_DEPENDENCIES
Columns
| Column | 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 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 DBLink name of the referenced object. |
| SCHEMAID | NUMBER | NO | The Schema ID of the current user. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | Indicates whether the dependency is a strong dependency. |