ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Tips--记录与Mview相关的所有表和视图

Tips--记录与Mview相关的所有表和视图

原创 Linux操作系统 作者:vongates 时间:2019-07-17 16:12:02 0 删除 编辑

在日常工作中很多时候我们会用到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>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29987/viewspace-51932/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-09-11

  • 博文量
    449
  • 访问量
    292714