|
-
Be Very Careful of Using Truncate in Source Database when Using Fast Mode MV
Issue the Truncate table command , Nothing is recorded in
MLOG$_xxx ,
DBMS_MVIEW.REFRESH(V_Mirror.Table_Name, 'F');
Will not work .
So in this case ,
DBMS_MVIEW.REFRESH(V_Mirror.Table_Name, 'C') must be used .
1. www.dbasupport.com
2. www.dbforums.com
3. www.itpub.net
4. www.csdn.net
5. www.umlchina.com
6. www.tek-tips.com
7. www.cnforyou.com
8. fm365.federal.com.cn
9. www.programmersheaven.com
10.http://msdn.microsoft.com/library/default.asp
[email protected]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|