Home > CONCEPTS > RECORDS FILTERING.

RECORDS FILTERING.

June 17, 2013

We can do the  rows filtering using table or map options.

Few important points on ROW filtering.

1) table option can be used in all stages like extract, datapump, replicate.

2) map options should be used in REPLICAT only.

1) ROWS filtering at extract procedure:-

extract LHRAMER1
userid gguser@AMER,password gguser
exttrail dirdat/CF
table HR.MYTESTTBL , where (SRNO < 1000);
table HR.MYTESTTBL2, where (SRNO < 2000);

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.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) ROWS 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
–passthru
userid gguser@amer, password gguser
RMTHOST auc01v574.us.oracle.com, mgrport 15001
rmttrail dirdat/CF
table HR.MYTESTTBL, where (SRNO < 1000);
table HR.MYTESTTBL2, where (SRNO < 2000);

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) ROWS 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.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, where (SRNO < 1000);
map hr.mytesttbl2, target hr.mytesttbl2, where (SRNO < 2000);

add replicat RHRAMER1, exttrail dirdat/CF

Advertisements
Categories: CONCEPTS
%d bloggers like this: