importing statistics using datapump
722909Sep 16 2009 — edited Sep 28 2009When importing production data into my test databases (schema imports) I want ot import the production statistics for the imported schemas, then lock them, so hopefully all testing will be done using the same explain plans.
When using expdp on production I do not specify eny EXCLUDE objects and when I impdp into my test DB it imported most of the stats but for 3 tables and all their indexes it regathererd the stats.
Any ideas which it recalculated stats for just 3 tables (+ indexes) and how I can avoid this.
The schemas I import into are droped and recreated prior to the import.