I have requirement to export multiple tables using datapump job and the ultimate goal is that we are doing a migration from on-Prem . They have something like 6TB of AUD data and we are not required to host all of that. We are trying to find a way to filter the AUD data in the export to only export and migrate the AUD data based upon a date to be determined.
Every AUD table has column change_date which can be used as filter. So based on the above requirement i have prepared the below job, but getting syntax error. Can you please help on this.
expdp system/xxxxxxx DIRECTORY=EXPDP_DIR DUMPFILE=test.dmp LOGFILE=test.log CONTENT=DATA_ONLY SCHEMAS=AUD INCLUDE=TABLE:"IN(select table_name from dba_tables where owner ='AUD';)" query="where change_date > to_date('31-Dec-2020','DD-MON-YYYY')"
-bash: syntax error near unexpected token `('