Home > CONCEPTS > OPERATIONS filtering.

OPERATIONS filtering.

June 17, 2013

Hi,

We can filter certain operations in the source and replicate them on the target.

FORMAT

filter(< OPRATION TYPE>, <somi condition>)

eg:- filter(ON DELETE, SRNO > 0)

note:- I need to check further more details on operations filter. Will keep updating them as and when i go through them.

 

operations filtering can be done at extract or datapump or replicate.

1) OPERATIONS filtering at extract procedure:

extract LHRAMER1
userid gguser@AMER,password gguser
exttrail dirdat/CF
Table HR.MYTESTTBL, FILTER (ON INSERT,ON DELETE, SRNO > 0);
table HR.MYTESTTBL2;

add extract LHRAMER1,tranlog ,begin now
add exttrail dirdat/CF,extract LHRAMER1, megabytes 100

extract PHRAMER1
userid gguser@amer, password gguser
RMTHOST auc01v574.us.oracle.com, mgrport 15001
rmttrail dirdat/CF
Table HR.MYTESTTBL;
table HR.MYTESTTBL2;

add extract PHRAMER1, exttrailsource dirdat/CF
add rmttrail dirdat/CF,extract PHRAMER1, megabytes 100

replicat rhramer1
assumetargetdefs
discardfile ./dirrpt/CF.dsc, purge
userid gguser@EURO, password gguser
map hr.mytesttbl, target hr.mytesttbl;
map hr.mytesttbl2, target hr.mytesttbl2;

add replicat RHRAMER1, exttrail dirdat/CF

2) OPERATIONS filtering at datapump procedure:

extract LHRAMER1
userid gguser@AMER,password gguser
exttrail dirdat/CF
table HR.MYTESTTBL;
table HR.MYTESTTBL2;

add extract LHRAMER1,tranlog ,begin now
add exttrail dirdat/CF,extract LHRAMER1, megabytes 100

extract PHRAMER1
userid gguser@amer, password gguser
RMTHOST auc01v574.us.oracle.com, mgrport 15001
rmttrail dirdat/CF
Table HR.MYTESTTBL, FILTER (ON INSERT,ON DELETE, SRNO > 0);
table HR.MYTESTTBL2;

add extract PHRAMER1, exttrailsource dirdat/CF
add rmttrail dirdat/CF,extract PHRAMER1, megabytes 100

replicat rhramer1
assumetargetdefs
discardfile ./dirrpt/CF.dsc, purge
userid gguser@EURO, password gguser
map hr.mytesttbl, target hr.mytesttbl;
map hr.mytesttbl2, target hr.mytesttbl2;

add replicat RHRAMER1, exttrail dirdat/CF

3) OPERATIONS filtering at replication procedure:

extract LHRAMER1
userid gguser@AMER,password gguser
exttrail dirdat/CF
table HR.MYTESTTBL;
table HR.MYTESTTBL2;

add extract LHRAMER1,tranlog ,begin now
add exttrail dirdat/CF,extract LHRAMER1, megabytes 100

extract PHRAMER1
–passthru
userid gguser@amer, password gguser
RMTHOST auc01v574.us.oracle.com, mgrport 15001
rmttrail dirdat/CF
–table HR.MYTESTTBL;
Table HR.MYTESTTBL;
table HR.MYTESTTBL2;

add extract PHRAMER1, exttrailsource dirdat/CF
add rmttrail dirdat/CF,extract PHRAMER1, megabytes 100

replicat rhramer1
assumetargetdefs
discardfile ./dirrpt/CF.dsc, purge
userid gguser@EURO, password gguser
map hr.mytesttbl, target hr.mytesttbl, FILTER (ON INSERT,ON DELETE, SRNO > 0);
map hr.mytesttbl2, target hr.mytesttbl2;

add replicat RHRAMER1, exttrail dirdat/CF

 

Advertisements
Categories: CONCEPTS
%d bloggers like this: