在日常工作中很多时候我们会用到MView这个高级的就用，下面记录在Oracle数据库中用常见的View和Table的列表，以后会对日常维护用经常使用的view作说明。

我们可以有通过下面的SQL来查看系统中我们经常使的表或视图

SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS T
WHERE T.object_name LIKE '%MVIEW%'
AND T.object_type IN ('VIEW','TABLE');

执行的结果如下：

SQL> SELECT OWNER,OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS T
2 WHERE T.object_name LIKE '%MVIEW%'
3 AND T.object_type IN ('VIEW','TABLE');

OWNER OBJECT_NAME OBJECT_TYPE
-------- --------------------------------- ------------------
SYS ALL_BASE_TABLE_MVIEWS VIEW
SYS ALL_MVIEWS VIEW
SYS ALL_MVIEW_AGGREGATES VIEW
SYS ALL_MVIEW_ANALYSIS VIEW
SYS ALL_MVIEW_DETAIL_RELATIONS VIEW
SYS ALL_MVIEW_JOINS VIEW
SYS ALL_MVIEW_KEYS VIEW
SYS ALL_MVIEW_LOGS VIEW
SYS ALL_MVIEW_REFRESH_TIMES VIEW
SYS ALL_REGISTERED_MVIEWS VIEW
SYS DBA_BASE_TABLE_MVIEWS VIEW
SYS DBA_MVIEWS VIEW
SYS DBA_MVIEW_AGGREGATES VIEW
SYS DBA_MVIEW_ANALYSIS VIEW
SYS DBA_MVIEW_DETAIL_RELATIONS VIEW
SYS DBA_MVIEW_JOINS VIEW
SYS DBA_MVIEW_KEYS VIEW
SYS DBA_MVIEW_LOGS VIEW
SYS DBA_MVIEW_LOG_FILTER_COLS VIEW
SYS DBA_MVIEW_REFRESH_TIMES VIEW
SYS DBA_REGISTERED_MVIEWS VIEW
SYS DBA_REGISTERED_MVIEW_GROUPS VIEW
SYS USER_BASE_TABLE_MVIEWS VIEW
SYS USER_MVIEWS VIEW
SYS USER_MVIEW_AGGREGATES VIEW
SYS USER_MVIEW_ANALYSIS VIEW
SYS USER_MVIEW_DETAIL_RELATIONS VIEW
SYS USER_MVIEW_JOINS VIEW
SYS USER_MVIEW_KEYS VIEW
SYS USER_MVIEW_LOGS VIEW
SYS USER_MVIEW_REFRESH_TIMES VIEW
SYS USER_REGISTERED_MVIEWS VIEW
SYSTEM MVIEW$_ADV_AJG TABLE
SYSTEM MVIEW$_ADV_BASETABLE TABLE
SYSTEM MVIEW$_ADV_CLIQUE TABLE
SYSTEM MVIEW$_ADV_ELIGIBLE TABLE
SYSTEM MVIEW$_ADV_EXCEPTIONS TABLE
SYSTEM MVIEW$_ADV_FILTER TABLE
SYSTEM MVIEW$_ADV_FILTERINSTANCE TABLE
SYSTEM MVIEW$_ADV_FJG TABLE
SYSTEM MVIEW$_ADV_GC TABLE
SYSTEM MVIEW$_ADV_INFO TABLE
SYSTEM MVIEW$_ADV_JOURNAL TABLE
SYSTEM MVIEW$_ADV_LEVEL TABLE
SYSTEM MVIEW$_ADV_LOG TABLE
SYSTEM MVIEW$_ADV_OUTPUT TABLE
SYSTEM MVIEW$_ADV_PARAMETERS TABLE
SYSTEM MVIEW$_ADV_PLAN TABLE
SYSTEM MVIEW$_ADV_PRETTY TABLE
SYSTEM MVIEW$_ADV_ROLLUP TABLE
SYSTEM MVIEW$_ADV_SQLDEPEND TABLE
SYSTEM MVIEW$_ADV_TEMP TABLE
SYSTEM MVIEW$_ADV_WORKLOAD TABLE
SYSTEM MVIEW_EVALUATIONS VIEW
SYSTEM MVIEW_EXCEPTIONS VIEW
SYSTEM MVIEW_FILTER VIEW
SYSTEM MVIEW_FILTERINSTANCE VIEW
SYSTEM MVIEW_LOG VIEW
SYSTEM MVIEW_RECOMMENDATIONS VIEW
SYSTEM MVIEW_WORKLOAD VIEW

60 rows selected

SQL>