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. Compile objects of a particular schema: EXEC DBMS_UTILITY.compile_schema(schema => 'APPS'); 3. Compiling individual...
oracle.com/en/database/oracle/oracle-database/21/arpls/UTL_RECOMP.html >275 UTL_RECOMP 其他参考 代码语言:javascript 代码运行次数:0 运行 AI代码解释 https://oracle-base.com/articles/misc/recompiling-invalid-schema-objects Recompiling Invalid Schema Objects Oracle オブジェクトを一括で再コンパイ...
SQL> select count(*) from dba_objects where status='INVALID'; adadmin->Change Maintenance Mode->2. Disenable Maintenance Mode 再重启应用即可 cd $ADMIN_SCRIPTS_HOME ./adadstral.sh apps apps PS : 1、编译整个数据库中的无效对象 SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql 2、编译数据库中单个的...
在SQL中查找无效对象很容易,我们可以使用“user_objects”或“all_objects”,这将向我们显示具有“无效”状态的对象。这些状态基于对象在表中的关系。 有特定的系统视图提供和存储信息,在 oracle 中,我们有“DBA_OBJECTS”,而 Microsoft SQL Server 和 MySQL 分别有“sys.objects”和“information_schema”。
dba_objects where status = 'INVALID' and object_type in ('PACKAGE','FUNCTION','PROCEDURE') ; spool off; set heading on; set feedback on; set echo on; @run_invalid.sql check the status of oracle component. selectcomp_id,comp_name,version,status,namespace,schemafromdba_registry;...
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. ...
SQL>selectcount(*),owner,status from all_objects where object_Type like'JAVA%'group by owner,status;COUNT(*)OWNERSTATUS---11999SYSVALID --这个数据明显和预计的差别很大。 需要卸载重新安装。 步骤如下: 代码语言:javascript 代码运行次数:0 运行...
Oracle Receivables - Version 12.1.3 and laterInformation in this document applies to any platform.SymptomsOn : 11.5.10.2 version, You are attempting to compile invalid objects, after patching, and receive the following error:ERROR---Errors for PACKAGE BODY APPS.AR_BILLS_MAINTAIN_STATUS_PUB:LINE/...
Invalid objects are found in Clarity or DWH database instance, which may or may not be affecting application functionality Environment Release: Any Supported Release Component: Cause Invalid objects can occur for various reasons. Some possible causes ...
SQL>SELECT*FROMDBA_OBJECTSWHEREOBJECT_NAMELIKE'WM_CONCAT%'; 解决办法有两种,一种是采用Oracle本身的脚本来创建WM_CONCAT函数,一种是采用自己创建的函数来解决这个问题。 1、用Oracle自带脚本重建WMSYS用户的WMSYS.WM_CONCAT函数 运行如下脚本卸载WMSYS用户的数据: ...