grant execute_catalog_role to system;

grant analyze any to system;

declare

source_part varchar2(10);

target_part varchar2(10);

BEGIN

source_part:='P'||to_char(sysdate-2,'yyyymmdd');

target_part:='P'||to_char(sysdate,'yyyymmdd');

DELETE SGPM.STAT_TAB;

dbms_stats.export_table_stats(ownname => 'SGPM',tabname => '',partname => source_part,stattab => 'STAT_TAB');

UPDATE SGPM.STAT_TAB A SET A.C2=target_part;

dbms_stats.delete_table_stats(ownname => 'SGPM',tabname => '',partname => target_part);

dbms_stats.import_table_stats(ownname => 'SGPM',tabname => '',partname => target_part,stattab => 'STAT_TAB');

end;

ITPub博客

手工复制统计信息