{統計}統計のエクスポート/インポート

 

https://docs.oracle.com/cd/F19136_01/tgsql/transporting-optimizer-statistics.html#GUID-B24DB1B4-ECA4-4F8B-9948-E1456FAF1819

orcl⇒PROD1

-- orcl

begin
DBMS_STATS.CREATE_STAT_TABLE (
   'sh', 
   'stattab');
end;
/

begin
DBMS_STATS.export_table_stats (
   'sh',
    'tokei',
   stattab =>'stattab');
end;
/

expdp system/oracle@orcl directory=ORA_DIR dumpfile=stat.dmp tables=sh.stattab

 

 

-- PRDO1
conn sh/sh

create table sh.tokei
(col1 number,
 col2 date,
 col3 varchar2(10),
 col4 number
)
partition by range(col1)
(partition p1 values less than(100),
 partition p2 values less than(200),
 partition p3 values less than(300),
 partition p4 values less than(maxvalue)
);

 

impdp system/oracle@PROD1 directory=ORA_DIR dumpfile=stat.dmp tables=sh.stattab

begin
DBMS_STATS.import_table_stats (
   'sh',
    'tokei',
   stattab =>'stattab');
end;
/

select * from dba_tables where table_name ='TOKEI';