ON CALL DBA SUPPORT

— Database blog

STEPS TO START ORACLE STREAMS

Posted by ssgottik on 14/04/2011

STEPS TO START STREAMS: Fallow the steps in same order

 APPLY_NAME = STREAM_APPLY_A1

CAPTURE_NAME = STREAM_CAPTURE_C1

PROPAGATION_NAME = STREAM_PROPAGATION_P1

 STEP 1. START THE APPLY PROCESS:

BEGIN

 DBMS_APPLY_ADM.START_APPLY(

apply_name => ‘STREAM_APPLY_A1’);

END;

/

STEP 2. START THE PROPAGATION PROCESS:

 BEGIN

DBMS_PROPAGATION_ADM.START_PROPAGATION(

propagation_name => ‘STREAM_PROPAGATION_P1’);

END;

/

STEP 3. START THE CAPTURE PROCESS

BEGIN

DBMS_CAPTURE_ADM.START_CAPTURE(

capture_name => ‘STREAM_CAPTURE_C1’);

END;

/

Advertisements

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

 
%d bloggers like this: