sql @$ORACLE_HOME/rdbms/admin/utlprp.sql DBMS_UTILITY.compile_schema编译数据库失效对象 DBMS_UTILITY包中的COMPILE_SCHEMA过程编译指定模式中的所有过程,函数,包和触发器。 例: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 EXEC DBMS_UTILITY.compile_schema(schema => 'SCOTT', compile_all => ...
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 time, depending on the number of objects. @$ORACLE_HOME/rdbms/admin/utlrp.sql 2....
where status = 'INVALID'; 2-If they are invalid please do the following: 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 ...
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), ...
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 : SQL> col comp_id format a10 SQL> col comp_name format a30
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 : SQL> col comp_id format a10 SQL> col comp_name format a30
2.Build-in scripts to recompile the invalid objects. We now have a supported script utlrp.sql located in the $ORACLE_HOME/rdbms/admin/utlrp.sql to do recompile for us. Below code will list out all the current invalid object and run utlrp.sql to compile all of them. ...
How to Re-Compile All Invalid for Oracle EBS Package/Package Body set serveroutput on size 1000000 declare sql_statement varchar2(200); cursor_id number; ret_val number; CURSOR cur_invalid IS select object_type, owner, object_name from sys.dba_objects o ...
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.4 [Release 9.2 to 10.2]Information in this document applies to any platform.SymptomsInvalid view SYS.KU$_XMLSCHEMA_VIEW Attempt to compile it gets ORA-22973SQL> alter view SYS.KU$_XMLSCHEMA_VIEW compile;alter view SYS.KU$_XML...
First, if any of the objects upon which the unit depends are invalid, the database recompiles them. The database also invalidates any local objects that depend upon the unit. If the database recompiles the unit successfully, then the unit becomes valid. Otherwise, the database returns ...