Note
This view is available starting with V3.1.2.
Purpose
This view displays the dependencies between objects in the current user's schema.
Applicability
This view is applicable only to OceanBase Database in Oracle mode.
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 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 name of the referenced database link. |
| 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. |
Sample query
Query the dependencies between objects in the current user's schema.
obclient [SYS]> SELECT * FROM SYS.USER_DEPENDENCIES;
The query result is as follows:
+-----------------+----------+------------------+------------------+-----------------+----------------------+----------+-----------------+
| NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE | REFERENCED_LINK_NAME | SCHEMAID | DEPENDENCY_TYPE |
+-----------------+----------+------------------+------------------+-----------------+----------------------+----------+-----------------+
| VERIFY_FUNCTION | FUNCTION | SYS | COMPLEXITY_CHECK | FUNCTION | NULL | 201006 | HARD |
| VERIFY_FUNCTION | SYNONYM | SYS | VERIFY_FUNCTION | FUNCTION | NULL | 201006 | HARD |
+-----------------+----------+------------------+------------------+-----------------+----------------------+----------+-----------------+
2 rows in set