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 .
|
+ Reply to Thread
Results 1 to 1 of 1
|
Click Here to Expand Forum to Full Width
|
Bookmarks