Re: datapump stats

On Sep 13, 4:54 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> chris.br..._at_providentinsurance.co.uk wrote:
> > What options do I have for refreshing stats when using a datapump
> > import ( at schema level ) ?
>
> > My current plan is to gather the stats after the import
>
> The following shows how the old imp utility's parameters map to DP
> import parameters:
>
> http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_imp...
>
> From this, you can see that there is no STATISTICS parameter with
> impdp. The above link will tell you what happens with respect to
> optimizer stats.
>
> If you are gathering stats after the import, does it really matter what
> impdp does?
>
> HTH,
> Brian
>
> --thanks for the post.

I want to be in control of stats because my stats program uses the repeat clause which means that it keeps any histograms that are already there.

cheers
Chris B
> ===================================================================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com
Received on Wed Sep 19 2007 - 05:53:38 CDT