dbms_mview系列(六)

wisdomone1發表於2013-03-03

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部落格 ” ,連結:http://blog.itpub.net/9240380/viewspace-755174/,如需轉載,請註明出處,否則將追究法律責任。

相關文章