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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s