Sample Header Ad - 728x90

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