二.编写拼接SQL编译 编写拼接sql 来批量手动编译 select'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'fromdba_objectswherestatus='INVALID'; 三.存储过程+调度任务定时编译 – 编译失效对象的存储过程 CREATEORREPLACEPROCEDUREcompile_all_invalid_objectsASBEGINFORobjIN(SELECTobject_name...
sql DBMS_UTILITY.compile_schema编译数据库失效对象 DBMS_UTILITY包中的COMPILE_SCHEMA过程编译指定模式中的所有过程,函数,包和触发器。 例: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 EXEC DBMS_UTILITY.compile_schema(schema => 'SCOTT', compile_all => false); UTL_RECOMP包编译数据库失效对象 ...
Oracle批量编译失效对象可以通过多种方式实现,包括使用PL/SQL脚本、Oracle提供的脚本工具以及DBMS_UTILITY和UTL_RECOMP包等。 方法一:使用PL/SQL脚本 你可以编写一个PL/SQL脚本来遍历所有无效的对象,并逐个进行编译。以下是一个示例脚本: plsql DECLARE CURSOR invalid_objects IS SELECT owner, object_name, object_...
To validate the invalid objects 1)-Please run the utlrp.sql script to try and validate the invalid packages, then check if they are valid or still invalid. 2 )-If the objects are still invalid after running the utlrp.sql script then run catalog.sql and catproc.sql and then run utlrp.sq...
/rdbms/admin/catproc.sql 6). @?/rdbms/admin/utlrp.sql 7). shutdown immediate 8). startup SELECT UNIQUE OBJECT_TYPE FROM ALL_objects where status = 'INVALID'; select 'ALTER ' || OBJECT_TYPE || ' '||owner||'.' || OBJECT_NAME || ' COMPILE;'...
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...
/rdbms/admin/catproc.sql 6). @?/rdbms/admin/utlrp.sql 7). shutdown immediate 8). startup SELECT UNIQUE OBJECT_TYPE FROM ALL_objects where status = 'INVALID'; select 'ALTER ' || OBJECT_TYPE || ' '||owner||'.' || OBJECT_NAME || ' COMPILE;'...
','TRIGGER','TRIGGER','PROCEDURE','PROCEDURE','FOUNCTION','FUNCTION','PACKAGE','PACKAGE','PACKAGE BODY','PACKAGE','MATERIALIZED VIEW')||' '||owner||'.'||object_name||' compile '||';'fromdba_objectswherestatuslike'INV%';spooloff;setheadingon;setfeedbackon;setechoon;@run_invalid.sql...
'PACKAGE','PACKAGE','PACKAGE BODY','PACKAGE','MATERIALIZED VIEW') ||' '||owner||'.'||object_name||' compile '||';' fromdba_objects wherestatuslike'INV%'; spooloff; setheadingon; setfeedbackon; setechoon; @run_invalid.sql
/rdbms/admin/catproc.sql 6). @?/rdbms/admin/utlrp.sql 7). shutdown immediate 8). startup SELECT UNIQUE OBJECT_TYPE FROM ALL_objects where status = 'INVALID'; select 'ALTER ' || OBJECT_TYPE || ' '||owner||'.' || OBJECT_NAME || ' COMPILE;'...