ON CALL DBA SUPPORT

– Database blog

STEPS TO STOP STREAMS

Posted by ssgottik on 14/04/2011

STEPS TO STOP STREAMS:


APPLY_NAME = STREAM_APPLY_A1
CAPTURE_NAME = STREAM_CAPTURE_C1
PROPAGATION_NAME = STREAM_PROPAGATION_P1

Execute the below steps with streams administrator user only:

STEP 1. STOP THE APPLY PROCESS:
BEGIN
  DBMS_APPLY_ADM.STOP_APPLY(
    apply_name => ‘STREAM_APPLY_A1′);
END;
/
STEP 2. STOP THE PROPAGATION PROCESS:
BEGIN
  DBMS_PROPAGATION_ADM.STOP_PROPAGATION(
    propagation_name => ‘STREAM_PROPAGATION_P1′);
END;
/
STEP 3. STOP THE CAPTURE PROCESS

BEGIN
  DBMS_CAPTURE_ADM.STOP_CAPTURE(
    capture_name => ‘STREAM_CAPTURE_C1′);
END;
/

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 51 other followers

%d bloggers like this: