1，利用$ORACLE_HOME/rdbms/admin下的utlrp.sql脚本编译.一般都是在迁移或者升级之后运行该脚本.
2，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博客

IMP-00041: Warning: object created with compilation warnings

最新文章