Data Correction in Oracle Streaming Setup

Note: Please make sure that which data is right and which data is wrong so accordingly you have to connect the
source or destination-site site

for example. for these specific subsciber data was wrong in destination-site so we do connect with destination-site

sqlplus scott/***********@sdb
Note: sdb is the alias for connect the destination-site database

SQL>exec DBMS_STREAMS.SET_TAG('ff');

Note:- make sure that you have to do set tag on before make any data correction so when you do perform any
data change that data never go to replicate inside the source site and it’s only keep change in destination-site

SQL>select ID,CUSTOMERSTATUS,USER_IDENTITY, RADIUSPOLICY from myradiuscustomer where CUI='918925991771';

SQL>UPDATE myradiuscustomer
    SET CUSTOMERSTATUS='inactive'
    where CUI='918925991771';

1 row updated

Note:- make sure that data is update for specific one subscriber only

SQL>select ID,CUSTOMERSTATUS,USER_IDENTITY, RADIUSPOLICY from myradiuscustomer where CUI='918925991771';
Note:- make sure that data is update correctly

SQL>exec DBMS_STREAMS.SET_TAG(null);
Note:- make sure that you have to have do set tag as null before exit the sql session

SQL>exit;

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.