Note
- This view is available starting with V4.4.0 for V4.4.x.
- This view is available starting with V4.3.5 BP2 for V4.3.5.
Purpose
This view displays the dependencies of materialized views in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| MVIEW_OWNER | VARCHAR2(128) | YES | The name of the materialized view owner. |
| MVIEW_NAME | VARCHAR2(256) | YES | The name of the materialized view. |
| DEP_OWNER | VARCHAR2(128) | YES | The name of the dependent object owner. |
| DEP_NAME | VARCHAR2(256) | YES | The name of the dependent object. |
| DEP_TYPE | CHAR(64) | NO | The type of the dependent object:
|
Sample query
Query the dependencies of materialized views in the current tenant.
obclient> SELECT * FROM sys.DBA_MVIEW_DEPS;
The return result is as follows:
+-------------+------------------+-----------+---------------+------------------------------------------------------------------+
| MVIEW_OWNER | MVIEW_NAME | DEP_OWNER | DEP_NAME | DEP_TYPE |
+-------------+------------------+-----------+---------------+------------------------------------------------------------------+
| SYS | MV_EXT_TBL1 | SYS | EXT_TBL1 | EXTERNAL TABLE |
| SYS | MV1_TBL3_TBL4 | SYS | TBL3 | TABLE |
| SYS | MV1_TBL3_TBL4 | SYS | TBL4 | TABLE |
| SYS | MV_MV1_TBL3_TBL4 | SYS | MV1_TBL3_TBL4 | MV |
+-------------+------------------+-----------+---------------+------------------------------------------------------------------+
4 rows in set