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[ I
ITPUB个人空间7Z,yernK:W2X
SQL> select *
]o r0zha!M*~OS0  2  from dba_mview_logsITPUB个人空间*B q ` ?Z|\5l/MQE
  3  where master = 'ACCOUNTS';ITPUB个人空间;dve5dAk
 ITPUB个人空间,NR#NG?#d-iJ
Refresh the materialized view ACC_VIEW using fast refresh.ITPUB个人空间2~ am4P/Z8Wv

Cv-YZ@xC `Q0execute dbms_mview.refresh('ACC_VIEW','F')
V,V?Z@ L1b0ITPUB个人空间3^ Gb~[J2hpDm
The '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:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-08-30  
     12
3456789
10111213141516
17181920212223
24252627282930
31      

数据统计

  • 访问量: 471
  • 日志数: 637
  • 建立时间: 2008-01-18
  • 更新时间: 2008-08-23

RSS订阅

Open Toolbar