Oracle 11gR2 – Expdp Full Database With Exclude Some Table Data

The question:

We will migrate our database using datapump.

It will be full database export with exclude some table’s datas.

But we want to do a different operation for 2 different tables. We want to export the data of the last 1 year for these 2 tables (let them be named table3 and table4). How can I write a query for this? The parfile I prepared is as follows, which commands should I add for these 2 tables?


At the same time, does this query slow down the process and is it recommended?

Thank you. Best Regards.

The Solutions:

Below are the methods you can try. The first solution is probably the best. Try others if the first one doesn’t work. Senior developers aren’t just copying/pasting – they read the methods carefully & apply them wisely to each case.

Method 1

You must use the QUERY clause for those tables, something like this:

QUERY=table3:"WHERE date3>=TO_DATE('20190101','YYYYMMDD')",table4:"WHERE date4>=TO_DATE('20190101','YYYYMMDD')"

date3 and date4 being the date column of those tables.

All methods was sourced from or, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Comment