ALL_DEPENDENCIES

2025-12-02 03:06:22  Updated

Purpose

The ALL_DEPENDENCIES view displays the dependencies among all the objects accessible to the current user.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.

  • DBA_DEPENDENCIES

  • USER_DEPENDENCIES

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 DBlink name of the referenced object.
DEPENDENCY_TYPE VARCHAR2(4) NO Indicates whether the dependency is a strong dependency.

Contact Us