Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datapump only statistics

rg2May 8 2009 — edited May 8 2009

Hi,

If I only wanted to export the stats from a schema, would this suffice?

expdp user/**** DIRECTORY=XYZ = SCHEMAS=APP_SCHEMA DUMPFILE=app_schema.dmp LOGFILE=app_schema.log INCLUDE=STATISTICS

I feel like I am missing something here or I would need more.

Please help.

What I am trying to do is save a copy of the stats, then refresh the DB and re-apply the stats as well as move the stats onto another system and DB.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 5 2009

Added on May 8 2009

#general-database-discussions

4 comments

2,739 views