手工复制统计信息

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博客 ” ，链接：http://blog.itpub.net/7191998/viewspace-753974/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7191998/viewspace-753974/