SELECT apply_name, apply_captured, status FROM dba_apply;
begin
dbms_apply_adm.stop_apply(apply_name => 'streams_apply');
end;
begin
dbms_apply_adm.start_apply(apply_name => 'streams_apply');
end;
begin
dbms_apply_adm.stop_apply(apply_name => 'streams_apply');
end;
begin
dbms_apply_adm.start_apply(apply_name => 'streams_apply');
end;