Sample Header Ad - 728x90

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

0 votes
1 answer
2480 views
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.
Asked by jrdba123 (29 rep)
Apr 8, 2022, 11:48 PM
Last activity: Apr 10, 2022, 01:08 AM