Note
This view is introduced in V3.1.2.
Purpose
This view displays the dependency relationships among objects in the current user's schema.
Applicability
This view applies 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 Dblink for the referenced object. |
| SCHEMAID | NUMBER | NO | The schema ID corresponding to the current user. |
| DEPENDENCY_TYPE | VARCHAR2(4) | NO | Indicates whether the dependency is a strong dependency or another type of dependency. |
Sample query
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