1. 查看数据库中的无效对象 check oracle object SQL> select count(*) from dba_objects where status='INVALID'; 2. 关闭应用,数据库和监听不能关闭 cd $ADMIN_SCRIPTS_HOME ./adadstpall.sh apps/apps 3. 用APP用户,执行adadmin打开维护模式并重新编译APPS Schema; 打开维护模式 adadmin->Change Maintenance...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
这些状态基于对象在表中的关系。 有特定的系统视图提供和存储信息,在 oracle 中,我们有“DBA_OBJECTS”,而 Microsoft SQL Server 和 MySQL 分别有“sys.objects”和“information_schema”。
Compiling individually did not solve the issue: the object would not compile.SQL>alter view sys.DBA_HIST_DATABASE_INSTANCE compile;Warning: View altered with compilation errors.SQL>alter view sys.dba_hist_snapshot compile;Warning: View altered with compilation errors....
oracle ora-29280: invalid directory object 文心快码BaiduComate 当遇到Oracle错误ORA-29280: invalid directory object时,这通常意味着Oracle数据库试图访问一个无效的目录对象。以下是根据你的提示,分步骤解答如何解决这个问题: 1. 确认Oracle数据库中的目录对象是否存在 首先,需要确认数据库中是否存在你试图访问的目录...
OWNER || '.' || OBJECT_NAME || ' COMPILE;' from 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. ...
object_name || ' COMPILE'; END LOOP; END; / 例2: 代码语言:javascript 复制 --生成手动编译无效对象的脚本,然后执行脚本。 SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' FROM DBA_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE IN ('...
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. ...
关于oraclePLSQL存储过程PLS-00905objectisinvalid，sta。。。昨天在学习oracle存储过程的时候，写了⼀个存储过程的demo，语句是这样的：CREATE OR REPLACE PROCEDURE RAISESALARY(PNAME IN VARCHAR2(20))AS psssal TESTDELETE.TESTID%TYPE;BEGIN SELECT TESTID INTO psssal FROM TESTDELETE WHERE TESTNAME=PNAME;UP...
Description:invalid object for describe Cause:The object to be described is not valid. It either has compilation or authorization errors. Action:The object to be described must be valid. Understanding Oracle Database Error Code ORA-24372