Note
This view is introduced in V3.1.2.
Purpose
The USER_DEPENDENCIES view displays the dependencies among objects in the schema of the current user.
Applicability
This view applies only to the Oracle mode of OceanBase Database.
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. |
Example
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 (0.207 sec)