Option1: The CONTENT=METADATA_ONLY is incompatible with ESTIMATE=STATISTICS
ORA-39178: cannot perform estimate on metadata only jobs
Option2: When using SAMPLE=0.25 instead, I get the following
ORA-39202: Data cannot be filtered or selected in CONTENT=METADATA_ONLY jobs.
On Sunday, October 23, 2016 12:13 PM, Mladen Gogala
<gogala.mladen@xxxxxxxxx> wrote:
Or, use SAMPLE=0.25. That should estimate statistics, based on the sample of
0.25% of the table data. The old and deprecated "exp" utility had an argument
which enabled it to skip the statistics collection altogether.
On 10/23/2016 03:09 AM, Martin Berger wrote:
Deepak,
based on this answer, did you try ESTIMATE=STATISTICS? This should not try
to "count blocks" for the estimates (and they are of no interest at all).
Martin
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217