export multiple tables using expdp with query condition
0
votes
3
answers
17687
views
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')\"
I am receiving the following error:
> -bash: syntax error near unexpected token `('
Asked by sarat
(60 rep)
Jul 12, 2022, 02:08 PM
Last activity: Jun 11, 2024, 04:09 AM
Last activity: Jun 11, 2024, 04:09 AM