Note
This view was introduced in V4.3.5 BP2.
Purpose
This view displays the dependency relationships of materialized views in the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| MVIEW_OWNER | varchar(128) | NO | The owner of the materialized view. |
| MVIEW_NAME | varchar(256) | NO | The name of the materialized view. |
| DEP_OWNER | varchar(128) | NO | The owner of the dependent object. |
| DEP_NAME | varchar(256) | NO | The name of the dependent object. |
| DEP_TYPE | varchar(64) | NO | The type of the dependent object:
|
Sample query
obclient [(none)]> SELECT * FROM oceanbase.DBA_MVIEW_DEPS;
Sample result:
+-------------+------------------+-----------+---------------+----------------+
| MVIEW_OWNER | MVIEW_NAME | DEP_OWNER | DEP_NAME | DEP_TYPE |
+-------------+------------------+-----------+---------------+----------------+
| db_test | mv_mv1_tbl3_tbl4 | db_test | mv1_tbl3_tbl4 | MV |
| db_test | mv1_tbl3_tbl4 | db_test | tbl4 | TABLE |
| db_test | mv1_tbl3_tbl4 | db_test | tbl3 | TABLE |
| db_test | mv_ext_tbl1 | db_test | ext_tbl1 | EXTERNAL TABLE |
+-------------+------------------+-----------+---------------+----------------+
4 rows in set