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. At present, only dependencies among Procedural Language (PL) objects are displayed.
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)