ITPub博客

首页 > 数据库 > 数据库开发技术 > Import statistics from another Datbase

Import statistics from another Datbase

原创 数据库开发技术 作者:sepulcrum 时间:2007-12-07 08:14:52 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    26
  • 访问量
    170246