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”。
The Oracle database will invalidate objects if a dependent object is changed. If I rebuild a table, the indexes on that table will become invalid because they use the table'srowidsand rebuilding the table changes a row'srowid. It is the same with objects like packages, procedures and functi...
SQL>SELECT*FROMDBA_OBJECTSWHEREOBJECT_NAMELIKE'WM_CONCAT%'; 解决办法有两种,一种是采用Oracle本身的脚本来创建WM_CONCAT函数,一种是采用自己创建的函数来解决这个问题。 1、用Oracle自带脚本重建WMSYS用户的WMSYS.WM_CONCAT函数 运行如下脚本卸载WMSYS用户的数据: ...
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. ...
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/...
SQL>SELECT*FROMDBA_OBJECTSWHEREOBJECT_NAMELIKE'WM_CONCAT%'; 解决办法有两种,一种是采用Oracle本身的脚本来创建WM_CONCAT函数,一种是采用自己创建的函数来解决这个问题。 1、用Oracle自带脚本重建WMSYS用户的WMSYS.WM_CONCAT函数 运行如下脚本卸载WMSYS用户的数据: ...
Oracle Cloud Infrastructure - Database Service - Version N/A and later Information in this document applies to any platform. Symptoms DBA Functions (like User Mgmt) SQL Developer v17.2 refers to an incorrect column while trying to display Export DATAPUMP job status in DBA menu tree. ...
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 ...