ITPub博客

首页 > Linux操作系统 > Linux操作系统 > IMP-00041: Warning: object created with compilation warnings

IMP-00041: Warning: object created with compilation warnings

原创 Linux操作系统 作者:rocky_gao 时间:2011-06-08 19:16:10 0 删除 编辑
dbms_utility.compile_schema()
3,select 'ALTER '||OBJECT_TYPE||' '||OBJECT_NAME||' COMPILE;' FROM DBA_OBJECTS WHERE WNER='USER_NAME' AND STATUS='INVALID';


SET SERVEROUTPUT ON SIZE 1000000
BEGIN
FOR object IN ( SELECT owner,
object_name,
object_type
FROM dba_objects
WHERE status != 'VALID')
LOOP
BEGIN
EXECUTE IMMEDIATE 'ALTER ' || object.object_type || ' ' || object.owner || '.' || object.object_name || ' COMPILE';
END;
END LOOP;
END;
/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11976525/viewspace-697439/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-04-09

  • 博文量
    112
  • 访问量
    278981