EXPDP with Select Query Clause in Oracle

EXPDP with Select Query Clause in Oracle

For exporting table data with query condition

1. Create the directory if not present.
create directory EXPDIR as 'D:\ORADUMP'

2. We export data from last 30 new employees to expdp dump file
select * from HR.EMPLOYEES WHERE created > sysdate-30;

3. Run the EXPDP command for export query data.

EXPDP Directory=EXPDIR dumpfile=employee.dmp logfile=employeeexp.log tables=hr.employees query=hr.employees:"WHERE created > sysdate - 30";

For IMPDP

IMPDP Directory=EXPDIR dumpfile=employee.dmp logfile=employeeimp.log

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.