This discussion is archived
2 Replies Latest reply: Apr 17, 2012 5:54 AM by hitgon RSS

remove streams process

INRi Explorer
Currently Being Moderated
how to remove existing STREAMS process???
  • 1. Re: remove streams process
    KuljeetPalSingh Guru
    Currently Being Moderated
    You run the REMOVE_STREAMS_CONFIGURATION procedure in the DBMS_STREAMS_ADM package to remove a Streams configuration at the local database.

    and for individual process try this guide
  • 2. Re: remove streams process
    hitgon Expert
    Currently Being Moderated
    Hi ,

    for remove the steams process

    you have to drop the stramadm users on source and destination database.
    no need to drop the tablespace of strmadmin user because while you reconfigure then you can use the existing tablespace the same and important thing is that if you drop the tablespace then it will invalidate the internal schema of log miner so when you again try to configure the streaming you stuckup
    the same.

    you have to follow the below cmds in source as well as destination database

    stop the apply and capture process

    connect / as sysdba


    drop user strmadmin cascade;

    check the following view and confirm all views are empty.

    SELECT * FROM sys.streams$_process_params;
    SELECT * FROM sys.streams$_rules;
    SELECT * FROM sys.streams$_capture_process;
    SELECT * FROM sys.streams$_apply_process;
    SELECT * FROM sys.streams$_apply_milestone;
    SELECT * FROM sys.streams$_apply_progress;

    Thanks and Regards


  • Correct Answers - 10 points
  • Helpful Answers - 5 points