二.编写拼接SQL编译 编写拼接sql 来批量手动编译 select'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'fromdba_objectswherestatus='INVALID'; 三.存储过程+调度任务定时编译 – 编译失效对象的存储过程 CREATEORREPLACEPROCEDUREcompile_all_invalid_objectsASBEGINFORobjIN(SELECTobject_name...
<VIEW_NAME> COMPILE; ALTER TRIGGER <SCHEMA).<TRIGGER_NAME> COMPILE; --查看是否有编译错误 show errors PL/SQL生成脚本编译所有无效用户对象 例1: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 --编译所有无效PROCEDURE对象BEGIN FOR cur IN ( SELECT object_name ,object_type FROM dba_objects ...
Oracle批量编译失效对象可以通过多种方式实现,包括使用PL/SQL脚本、Oracle提供的脚本工具以及DBMS_UTILITY和UTL_RECOMP包等。 方法一:使用PL/SQL脚本 你可以编写一个PL/SQL脚本来遍历所有无效的对象,并逐个进行编译。以下是一个示例脚本: plsql DECLARE CURSOR invalid_objects IS SELECT owner, object_name, object_...
In case you have lots of invalid objects,you can generate scripts that will generate the sqls for compiling the invalid objects : In sqlplus connect as sys: set heading off spool compileinvalid.sql select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from...
Below is the query to find the invalid objects currently present in the database. set pagesize 200 set lines 200 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 ti...
select 'ALTER PACKAGE ' || OWNER||'.'|| OBJECT_NAME || ' COMPILE body;' from ALL_objects where status = 'INVALID' and object_type in ('PACKAGE BODY'); SELECT UNIQUE OBJECT_TYPE FROM ALL_OBJECTS; 2. Verify that the status of the CATPROC : ...
select 'ALTER PACKAGE ' || OWNER||'.'|| OBJECT_NAME || ' COMPILE body;' from ALL_objects where status = 'INVALID' and object_type in ('PACKAGE BODY'); SELECT UNIQUE OBJECT_TYPE FROM ALL_OBJECTS; 2. Verify that the status of the CATPROC : ...
FROM dba_objects WHERE status = 'INVALID' ORDER BY owner, object_type, object_name; 1. 2. 3. 4. 5. 6. 7. 8. 少量直接alter, 注意包体需要加body ALTER PACKAGE my_package COMPILE; ALTER PACKAGE my_package COMPILE BODY; ...
Compile all invalid objects. Validate that the system is ready for cutover. If finalize_mode=full, compute statistics for key data dictionary tables for improved performance. Run the finalize phase as follows: $ adop phase=finalize Online Patching Cycle Steps - Cutover Phase ...
3.select 'alter procedure '||object_name||' compile;' from all_objects 4.where status = 'INVALID' and object_type = 'PROCEDURE' AND owner='UNMI'; 5. 6.spool off 7. 8.@ExecCompProc.sql; 2. 写成一个存储过程 -- 让这个存储过程在某个时机执行,比如 Job 中,代码如下: ...