I have a huge table and I want to find the size of the rows which are 6 months old out of historical data in the table using datapump
$ expdp directory=EXP_DIR nologfile=y query=table:\"where CRT_TS\>'01-JAN-15 06.07.03.799000000 AM'\" tables=SCHEMA.TABLE estimate_only=y
Export: Release 18.104.22.168.0 - Production on Thu Jun 25 15:48:46 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39202: Data cannot be filtered or selected in ESTIMATE_ONLY jobs.
According to oracle support this is reported as BUG in 11gr2, we cannot filter the data rows when doing ESTIMATES at the same time
“Bug 9536364 : DOC: DATA_FILTER AND ESTIMATE OPTIONS CANNOT BE USED TOGETHER IN DBMS_DATAPUMP”
Action: Do not restrict data handling on jobs that cannot support data filtering.