Re: Re: Very slow metadata-only expdp

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

2016-10-23 2:42 GMT+02:00 Deepak Sharma <dmarc-noreply_at_freelists.org>:

> Hi Jonathan,
>
> As per our open SR, this is what they responded with:
>
> My Question: Why is there no INSERT..SELECT when SCHEMAS=<schema> is
> specified, as compared to the full=Y ? Maybe that difference can help us
> disabled that step?
>
> Answer: This is because we skip the blocks method of estimating the export
> requirements which bypasses the INSERT..SELECT.
>
> -Deepak
>
>

--
http://www.freelists.org/webpage/oracle-l