首页 > Linux操作系统 > Linux操作系统 > dbms_mview系列(六)
REGISTER_MVIEW Procedure
此过程把每个物化视图纳入管理.在master site站点运行,从而注册物化视图,大多情况下,
物化视图在创建会自动注册,只有自动注册失败方可运行此过程或注册信息被删除
This procedure enables the administration of individual materialized views.
It is invoked at a master site or master materialized view site to register a materialized view.
Note that, typically, a materialized view is registered automatically during materialized view creation.
You should only run this procedure to manually register a materialized view if the automatic registration
failed or if the registration information was deleted.
Syntax
DBMS_MVIEW.REGISTER_MVIEW (
mviewowner IN VARCHAR2,
mviewname IN VARCHAR2,
mviewsite IN VARCHAR2,
mview_id IN DATE | BINARY_INTEGER,
flag IN BINARY_INTEGER,
qry_txt IN VARCHAR2,
rep_type IN BINARY_INTEGER := DBMS_MVIEW.REG_UNKNOWN);
此过程语义同上
UNREGISTER_MVIEW Procedure
This procedure enables the administration of individual materialized views.
It is invoked at a master site or master materialized view site to unregister a materialized view.
Syntax
DBMS_MVIEW.UNREGISTER_MVIEW (
mviewowner IN VARCHAR2,
mviewname IN VARCHAR2,
mviewsite IN VARCHAR2);
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9240380/viewspace-755174/ ,如需转载,请注明出处,否则将追究法律责任。