Subscriber Count

    448

Subscribe2

Pages

Contact for Online learnings
* indicates required field
Thanks for the inquiry. You will be receiving a mail shortly with course details. If not please check the spam folder once and mark our mail as not a spam.

Example 7: Filtering the Data

In this example we see how to filter the data changes to target side. i.e we can exclude some changes to the target side and skip them applying.

On Source Steps On Target Steps
Create Table create table test.myobj6 tablespace users  as select * from dba_objects; Create Table create table test.myobj6 tablespace users as select * from dba_objects where rownum < 1;
create extract for Initial Load add extract myload1, sourceistable

edit params myload1

EXTRACT myload1

USERID ggs_owner, PASSWORD ggs_owner

RMTHOST 192.168.56.109, MGRPORT 7809

RMTTASK replicat, GROUP myload1

TABLE test.myobj6, FILTER (@STRFIND (OBJECT_TYPE,'TABLE') > 0);

Create Replicat for special run add replicat myload1, specialrun

edit params myload1

REPLICAT myload1

USERID ggs_owner, PASSWORD ggs_owner

ASSUMETARGETDEFS

MAP test.myobj6, TARGET test.myobj6;

Create Extract for Online Synchronisation add extract myload2, tranlog, begin now

add rmttrail /u01/ggt_target/dirdat/bb, extract myload2

EXTRACT myload2

USERID ggs_owner, PASSWORD ggs_owner

RMTHOST 192.168.56.109, MGRPORT 7809

RMTTRAIL /u01/ggt_target/dirdat/bb

TABLE test.myobj6, FILTER (@STRFIND (OBJECT_TYPE, "INDEX") > 0);

Create Replicat for online synchornisation add replicat myload2, exttrail /u01/ggt_target/dirdat/bb

edit params myload2

REPLICAT myload2

ASSUMETARGETDEFS

USERID ggs_owner, PASSWORD ggs_owner

MAP test.myobj6, TARGET test.myobj6;

Start Extract start extract myload2 Start Replicat start replicate myload2
Insert data insert into test.myobj6 (object_name,object_type) values ('LLLL','INDEX'); insert into test.myobj6 (object_name,object_type) values ('XXXX','TABLE'); commit; Check Data select * from test.myobj6 where object_name='XXXX';

The following should return no rows since the extract filters the data type INDEX

select * from test.myobj6 where object_name='LLLL';