Data Migration using Oracle Datapump QUERY option

Consider the case when we want to migrate the selected records from source database to target database we have the below great technique available onwards 10g

I used QUERY option of Oracle Datapump tool for satisfy the requirements of Data Migration from source database to target database.
🙂

Approach-1
1. Taking backup using Oracle Datapump tool from source database
2. Move the backup on target database
3. Import the backup

OR

Approach-2
1. Create and configure database link in target database
2. Taking backup using Oracle Datapump tool from source database and import on target database using network_link option

expdp scott/******* parfile=mstpara.par

-bash-4.1$ cat mstpara.par
TABLES=EMP
directory=DB_ORCL
DUMPFILE=expdp_emp_test.dmp
logfile=expdp_emp_test.log
query=EMP:"where dept = '505'"

References

http://dba-oracle.com/t_oracle_expdp_tips.htm
http://amit7oracledba.blogspot.in/2013/12/query-parameter-in-datapump-utility.html
http://arjudba.blogspot.in/2008/04/exportimport-datapump-parameter-query.html
https://community.oracle.com/message/12587311
http://shaharear.blogspot.in/2008/09/using-query-parameter-in-expdpimpdp.html
http://arjudba.blogspot.in/2008/04/exportimport-datapump-parameter-query.html