Materialized View Logs (190)
A materialized view log is a schema object that records changes to a master table’s
data so that a materialized view defined on the master table can be refreshed
incrementally.
Each materialized view log is associated with a single master table. The materialized
view log resides in the same database and schema as its master table.
物化檢視日誌
1. 記錄主表資料變化的方案物件 , 使得定義在主表上的物化檢視能夠增量重新整理
2. 每個物化檢視日誌與一個主表相關 , 與主表位於同一資料庫同一方案
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10599713/viewspace-981947/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Materialized ViewZedView
- Extents in Materialized Views and Their Logs (18)ZedView
- drop materialized view hung !!!ZedView
- materialized view 的總結ZedView
- about materialized view and long(turn)ZedView
- materialized view (物化檢視)ZedView
- 利用materialized view同步資料ZedView
- materialized view基礎知識ZedView
- Oracle vs PostgreSQL Develop(20) - Materialized ViewOracleSQLdevZedView
- Synonym_View_Materialized和Public物件ViewZed物件
- How to Monitor the Progress of a Materialized View Refresh (MVIEW)ZedView
- 建立物化檢視MV ( Materialized View )ZedView
- 11g中的materialized view logZedView
- 轉:物化檢視(Materialized View)介紹ZedView
- mv(materialized view)的一點測試ZedView
- 【MW】Drop Materialized View Hangs with 'Enq: JI - Contention'ZedViewENQ
- oracle10g materialized view物化檢視示例OracleZedView
- ogg 同步 物化檢視建立限制 Materialized ViewZedView
- 建立Materialized view log時是否使用sequence clause的差別ZedView
- 跨DB主機抓取資料建議用MATERIALIZED VIEWZedView
- materialized view的fast和日誌分析和一則案例ZedViewAST
- oracle10g nested materialized view巢狀物化檢視示例OracleZedView巢狀
- zt_yangtinkung_ITPUB知識索引貼——物化檢視materialized view索引ZedView
- Data Warehouse Guide閱讀筆記(八):materialized view之一GUIIDE筆記ZedView
- 物化檢視(Materialized View)的重新整理回滾約束ZedView
- 物化檢視(Materialized View)的重新整理回滾測試ZedView
- RHEL7/CentOS7 type “journalctl -xb” to view system logsCentOSView
- 物化檢視日誌(materialized view log)引起大量Dfs Lock Handle等待ZedView
- oracle10g partition分割槽表與物化檢視materialized viewOracleZedView
- setting up materialized view sites for oracle10g advanced replication mvZedViewOracle
- flashback與dmt tbs以及trigger,materialized view log之間的關係!ZedView
- Overview of Materialized Views (184)ViewZed
- Refresh Materialized Views (189)ZedView
- [DW]An article about Materialized Views(zz)ZedView
- housekeep arch logs (tested on AIX)AI
- [轉]Trees in SQL: Nested Sets and Materialized PathSQLZed
- Materialized Views in data warehouse environment (185)ZedView
- [20230225]12c Real-time materialized view 實時物化檢視的應用.txtZedView