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 11.2.0.4.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 11.2.0.4.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.
0 comments:
Post a Comment