Andrew Fraser DBA

Move MV from one refresh group into another

select name, refgroup,rname from dba_refresh_children where name in ('MV1','MV2');
exec dbms_refresh.subtract('RGOWNER.RG1', 'MVOWNER.MV1')
exec dbms_refresh.add('RGOWNER.RG2', 'MVOWNER.MV1')

List refresh groups with:

select rowner, rname, count(*) from dba_refresh_children group by rname, rowner order by 1,2;