expdp with query clause - Oracle Database Script. --- For exporting table data with query condition ----select * from AODBA.EMP_TAB WHERE created > sysdate -40; -- Parfile cat expdp_query.par dumpfile=test.dmp logfile=test1.log directory=TEST tables=aodba.EMP_TAB QUERY=aodba.EMP_TAB:"WHERE created > sysdate -40"
--- For exporting table data with query condition ----select * from AODBA.EMP_TAB WHERE created > sysdate -40; -- Parfile cat expdp_query.par dumpfile=test.dmp logfile=test1.log directory=TEST tables=aodba.EMP_TAB QUERY=aodba.EMP_TAB:"WHERE created > sysdate -40"