That being said, you can use the DBMS_STATS package to export the object statistics. Then transfer those statistics
to the production database and import there, again using DBMS_STATS. Finally, use DBMS_STATS to lock down the statistics so that they cannot be changed.
Dig deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.