Partition Change-Tracking Without MV Logs
上一篇 /
下一篇 2008-01-24 10:25:14
/ 个人分类:Oracle Database Administrator
Fortunately, in Oracle Database 10g Release 2, PCT works without the need for MV logs.
zV3ZU{3UTJ$N0Let's see this in action. First, confirm that there is no MV log on the table ACCOUNTS.
ITPUB个人空间5s(s.H1[IITPUB个人空间7Z,yernK:W2XSQL> select *
]or0zha!M*~OS0 2 from dba_mview_logs
ITPUB个人空间*B q ` ?Z|\5l/MQE 3 where master = 'ACCOUNTS';
ITPUB个人空间;dve5dAk ITPUB个人空间,NR#NG?#d-iJRefresh the materialized view ACC_VIEW using fast refresh.
ITPUB个人空间2~am4P/Z8WvCv-YZ@xC `Q0execute dbms_mview.refresh('ACC_VIEW','F')
V,V?Z@
L1b0ITPUB个人空间3^ Gb~[J2hpDmThe 'F' parameter indicates a fast refresh. But will it work without an MV log on the table?
to$R%f@-aS6h0ITPUB个人空间]9hOU.~.?;~v(__Refresh all materialized view with :
D(|yJ!Hu??0execute dbms_mview.REFRESH_ALL_MVIEWS;
y5T)cMUU O0
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG: