For Oracle11G EXPDP
Data between a month of a table should be required
Expdp help = Y
QUERY
Predicate clause used to export a subset of a table.
For example, QUERY = employees: "WHERE department_id> 10 ".
So expdp shark/2013 directory = dir_dp dumpfile = traderecord. dmp query = traderecord: "where tr_datetime> = to_date ('2017-03-01 ', 'yyyy-mm-dd') and tr_datetime <to_date ('2017-04-01 ', 'yyyy-mm-dd ')"
LRM-00116: syntax error at ') 'Following 'yyyy-mm-dd'
So add the transfer symbol.
] Expdp shark/2013 directory = dir_dp dumpfile = traderecord. dmp query = traderecord: \ "where tr_datetime \> = to_date \ (\ '2017-03-01 \ '\, \ 'yyyy-mm-dd \'\) and tr_datetime \ <to_date \ (\ '1970-04-01 \ ', \ 'yyyy-mm-dd \'\)\"
Export: Release 11.2.0.1.0-Production on Tue Apr 1 14:30:47 2014
Copyright (c) 1982,200 9, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "CCPS ". "SYS_EXPORT_SCHEMA_01": shark/******** directory = dir_dp dumpfile = traderecord. dmp query = traderecord: "where tr_datetime> = to_date ('2017-03-01 ', 'yyyy-mm-dd') and tr_datetime <to_date ('2017-04-01 ', 'yyyy-mm-dd ')"
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10.92 GB
No, there are so many transfers !!