expdp with query clause
--- For exporting table data with query condition
oracle configurationintermediate
by OracleDba
12 views
📋Steps in this guide1/1
1
expdp with query clause
Code/Command (click line numbers to comment):
123456789
--- For exporting table data with query condition
----select * from DBACLASS.EMP_TAB WHERE created > sysdate -40;
-- Parfile
cat expdp_query.par
dumpfile=test.dmp
logfile=test1.log
directory=TEST
tables=dbaclass.EMP_TAB
QUERY=dbaclass.EMP_TAB:"WHERE created > sysdate -40"Comments (0)
Please to add comments
No comments yet. Be the first to comment!