Re: datapump stats

chris.brown_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_import.htm#sthref389

 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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://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 from http://www.teranews.com