1.ORACLE 数据库分析:
begin
dbms_stats.gather_schema_stats(ownname=> 'OMS' , cascade=> TRUE);
end;
dbms_stats.gather_schema_stats(ownname=> 'OMS' , cascade=> TRUE);
end;
2.重新编译失败过程:
begin
dbms_utility.compile_schema('oms',false,false);
end;
dbms_utility.compile_schema('oms',false,false);
end;