Oracle 10gR2 Streams Delete All configurations

Oracle Streams has been configured for a long time. For some reasons it is not officially used, you need to completely clear its configuration information. Streams consists of three parts: capture, progapation, and apply, and some basic configuration information.

If you delete the configuration information, the streams is completely cleared.

Stop and delete the capture process

SQL> select capture_name, status from dba_capture;

CAPTURE_NAME STATUS
--------------------------------------
STRMADMIN_CAPTURE DISABLED

SQL> exec dbms_capture_adm.stop_capture ('strmadmin _ CAPTURE ');

PL/SQL procedure successfully completed.

SQL> exec dbms_capture_adm.drop_capture ('strmadmin _ CAPTURE ');

PL/SQL procedure successfully completed.

 

Stop and delete the propagation process

SQL> select propagation_name, status from dba_propagation;

PROPAGATION_NAME STATUS
--------------------------------------
STRMADMIN_PROPAGATE DISABLED

SQL> exec dbms_propagation_adm.drop_propagation ('strmadmin _ PROPAGATE ');

PL/SQL procedure successfully completed.

Stop and delete the apply Process

SQL> select apply_name, status from dba_apply;

No rows selected

Clear the entire streams Configuration

SQL> exec dbms_streams_adm.remove_streams_configuration;

PL/SQL procedure successfully completed.

The database initialization parameter streams_pool_size can also be reduced.