Oracle Streams - Strart and Stop

Oracle Streams - Strart and Stop

Start Streams.

1. Start Capture.
BEGIN
DBMS_CAPTURE_ADM.START_CAPTURE(
capture_name => 'STREAM1_CAPTURE');
END;
/

2. Start Progapation.
BEGIN
dbms_propagation_adm.start_propagation(
PROPAGATION_NAME=>'STREAM1_PROPOGATION');
END;
/

3. Start Apply.
BEGIN
DBMS_APPLY_ADM.START_APPLY(
apply_name => 'APPLY1_STREAM');
END;
/

Stop Streams.

1. Stop Apply.
BEGIN
DBMS_APPLY_ADM.STOP_APPLY(
apply_name => 'APPLY1_STREAM');
END;
/

2. Stop Progagation
BEGIN
dbms_propagation_adm.stop_propagation(
PROPAGATION_NAME=>'STREAM1_PROPOGATION');
END;
/

3. Stop Capture.
BEGIN
DBMS_CAPTURE_ADM.STOP_CAPTURE(
capture_name => 'STREAM1_CAPTURE');
END;
/