Note
This view is introduced in V3.1.2.
Purpose
The DBA_DEPENDENCIES view displays the dependencies among all objects in the database. 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 |
|---|---|---|---|
| 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. |
Example
obclient [SYS]> SELECT * FROM SYS.DBA_DEPENDENCIES;
The query result is as follows:
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
| OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE | REFERENCED_LINK_NAME | DEPENDENCY_TYPE |
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
| SYS | VERIFY_FUNCTION | FUNCTION | SYS | COMPLEXITY_CHECK | FUNCTION | NULL | HARD |
| __public | VERIFY_FUNCTION | SYNONYM | SYS | VERIFY_FUNCTION | FUNCTION | NULL | HARD |
+----------+-----------------+----------+------------------+------------------+-----------------+----------------------+-----------------+
2 rows in set (0.207 sec)