Move MV from one refresh group into another
1 | select name, refgroup,rname from dba_refresh_children where name in ('MV1','MV2'); |
2 | exec dbms_refresh.subtract('RGOWNER.RG1', 'MVOWNER.MV1') |
3 | exec dbms_refresh.add('RGOWNER.RG2', 'MVOWNER.MV1') |
List refresh groups with:
1 | select rowner, rname, count(*) from dba_refresh_children group by rname, rowner order by 1,2; |
Leave a Reply