Feature
USER_DEPENDENCIES 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 topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL 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 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 database link 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. |