Import statistics from another Datbase

Steps to export/import db statistics between 2 databases.

Here schema_name1 = schema_name2

rem 1) Create the holding table using DBMS_STATS in production DB1
exec dbms_stats.create_stat_table('schema_name1','table_name1');

rem 2) Move the statistics to the STATS holding table in Production DB1 for backup purpose
exec dbms_stats.export_schema_stats('schema_name1','table_name1');

rem 3) Create the holding table using DBMS_STATS in DB2
exec dbms_stats.create_stat_table('schema_name2','table_name2');

rem 4) Move the statistics to the table_name2 holding table in DB2
exec dbms_stats.export_schema_stats('schema_name2','table_name2');

rem 5) Export and Import the data in the table_name2 table in schema_name2 schema in DB2
exp uid/passwd tables=table_name2 file=expstat.dmp

rem 6) Then on the new database, run import in schema_name1 schema in production DB1
imp uid/passwd file=expstat.dmp full=y log=implog.log

rem 7) To Import statististics for an entire schema in production DB1
exec dbms_stats.import_schema_stats('schema_name1','table_name1');

rem 8) Drop the table_name2 holding tables

Rollback plan:
Delete the imported statistics and import back the original statistics.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10897379/viewspace-989146/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10897379/viewspace-989146/