object_name || ' COMPILE'; END LOOP; END; / 例2: 代码语言:javascript 复制 --生成手动编译无效对象的脚本,然后执行脚本。 SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' FROM DBA_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE IN ('...
Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
点第一个,按住shift键点最后一个,右键recompile就OK了
select owner,object_name,object_type,status from dba_objects where STATUS='INVALID'; 1. Compile all the objects of the database using UTLRP.SQL. This script may take some time, depending on the number of objects. @$ORACLE_HOME/rdbms/admin/utlrp.sql ...
SQL> @C:UsersAdministratorDesktopaq eCompile.sql; 备注:运行脚本reCompile.sql的时候,会创建另一个脚本run_invalid, 紧跟着执行该脚本,完成编译工作 1. 2. 3. 4. 5. 5 编写PL/SQL利用游标编译 declare v_object_name user_objects.object_name%type; ...
-- 重新编译单个存储过程 ALTER PROCEDURE my_procedure COMPILE; -- 重新编译所有无效的存储过程 SELECT 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;' FROM USER_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PROCEDURE'; 自动重新编译脚本示例: 代码语言:txt 复制 DECLARE v_sql VARCHAR2(40...
打开维护模式 adadmin->Change Maintenance Mode->1. Enable Maintenance Mode 重新编译APPS Schema Compile/Reload Applications Database Entities menu-> 1. Compile APPS schema 4. 检查无效对象的数量,关闭维护模式,启动应用 SQL> select count(*) from dba_objects where status='INVALID'; ...
DOC> utlirp.sql completed successfully. All PL/SQL objects in theDOC> database have been invalidated.DOC>DOC> Shut down and restart the database in normal mode and run utlrp.sql toDOC> recompile invalid objects.DOC>###也就是说,这个脚本的作用是使数据库中的PL/SQL对象INVALID,然后通过utlrp....
Invalid SYS objects cannot be recompiled.The issue started with an alert log messages: ORA-04063: package body "SYS.DBMS_SQLTUNE" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE".When the DBA tried to recompile this package body (as sysdba), ...