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?
DUMPFILE=dbname_datefull.dmp LOGFILE=dbname_datefulllog.log FULL=Y DIRECTORY=EXPORT_DATE EXCLUDE=STATISTICS EXCLUDE=TABLE_DATA:"= 'table1'" EXCLUDE=TABLE_DATA:"= 'table2'" --queryfortable3 --queryfortable4 FLASHBACK_TIME=SYSTIMESTAMP
At the same time, does this query slow down the process and is it recommended?
Thank you. Best Regards.
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.
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 stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0