begin -- on the source dbms_stats.create_stat_table('',' ',' '); dbms_stats.export_database_stats(' ',' ',' '); -- on the target -- first impdp stats table dbms_stats.import_database_stats(' ',' ',' '); end; /
I give it a try and I am very glad of the results. The main problem with exporting and importing the statistics with the Data Pump is the operation duration - using dbms_stats will take a fraction of time spent on the export and import with the Data Pump technology.
No comments:
Post a Comment