当前位置: 代码迷 >> Oracle管理 >> 查看oracle的dbms_mview系统包中有哪些函数或存储过程解决方案
  详细解决方案

查看oracle的dbms_mview系统包中有哪些函数或存储过程解决方案

热度:291   发布时间:2016-04-24 04:03:54.0
查看oracle的dbms_mview系统包中有哪些函数或存储过程
因为需要,现在想 查看oracle的dbms_mview系统包中有哪些函数或存储过程,这些函数或存储 过程都是什么功能,有什么办法吗?
------解决思路----------------------
只用过 dbms_mview,refresh(),手动刷新物化视图,其他的没有用过,百度一下应该能查到吧。
------解决思路----------------------
SQL> desc dbms_mview
PROCEDURE BEGIN_TABLE_REORGANIZATION
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 TABOWNER                       VARCHAR2                IN
 TABNAME                        VARCHAR2                IN
PROCEDURE DROP_SNAPSHOT
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MOWNER                         VARCHAR2                IN
 MASTER                         VARCHAR2                IN
 SNAPSHOT                       DATE                    IN
PROCEDURE END_TABLE_REORGANIZATION
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 TABOWNER                       VARCHAR2                IN
 TABNAME                        VARCHAR2                IN
PROCEDURE ESTIMATE_MVIEW_SIZE
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 STMT_ID                        VARCHAR2                IN
 SELECT_CLAUSE                  VARCHAR2                IN
 NUM_ROWS                       NUMBER                  OUT
 NUM_BYTES                      NUMBER                  OUT
PROCEDURE EXPLAIN_MVIEW
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MV                             VARCHAR2                IN
 STMT_ID                        VARCHAR2                IN     DEFAULT
PROCEDURE EXPLAIN_MVIEW
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MV                             CLOB                    IN
 STMT_ID                        VARCHAR2                IN     DEFAULT
PROCEDURE EXPLAIN_MVIEW
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MV                             VARCHAR2                IN
 MSG_ARRAY                      EXPLAINMVARRAYTYPE      IN/OUT
PROCEDURE EXPLAIN_MVIEW
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MV                             CLOB                    IN
 MSG_ARRAY                      EXPLAINMVARRAYTYPE      IN/OUT
...................................................................................
PROCEDURE WRAP_UP
参数名称                       类型                    输入/输出默认值?
------------------------------ ----------------------- ------ --------
 MOWNER                         VARCHAR2                IN
 MASTER                         VARCHAR2                IN
 SSHOT                          DATE                    IN
 STIME                          DATE                    IN

SQL>


http://docs.oracle.com/database/121/ARPLS/d_mview.htm#ARPLS67185
  相关解决方案