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
Last activity: Apr 10, 2022, 01:08 AM