All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

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';