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...
oracle ora-29280: invalid directory object 文心快码BaiduComate 当遇到Oracle错误ORA-29280: invalid directory object时,这通常意味着Oracle数据库试图访问一个无效的目录对象。以下是根据你的提示,分步骤解答如何解决这个问题: 1. 确认Oracle数据库中的目录对象是否存在 首先,需要确认数据库中是否存在你试图访问的目录...
OracleDatabase11g Enterprise Edition Release11.2.0.1.0-64bitProductionWiththe Partitioning, OLAP, Data MiningandRealApplication Testing optionsCREATEORREPLACEPROCEDURERAISESALARY(PNAMEINVARCHAR2(20))2AS3psssal TESTDELETE.TESTID%TYPE;4BEGIN5SELECTTESTIDINTOpsssalFROMTESTDELETEWHERETESTNAME=PNAME;UPDATETESTDE...
COUNT(*) OBJECT_COUNT FROM DBA_OBJECTS WHERE STATUS <> 'VALID' 2 GROUP BY OWNER,OBJECT_TYPE order by OWNER,OBJECT_TYPE; OWNER OBJECT_TYPE OBJECT_COUNT --- --- --- TEST PROCEDURE 1 TESTC100 FUNCTION 2 例2: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 SQL> SET LINES 333 PAGES...
https://stackoverflow.com/questions/48497140/oracle-sql-stored-procedure-object-invalid 楼主在里面发现了这么一句话: You can’t give a size or precision restriction for the data type of a formal parameter to a function or procedure, so NUMBER(10,0) should just be NUMBER; ...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
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. ...
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
or if it needs to be rectify whats steps need to be perform if i don't want to reimport back. Please help i need a solution for this as the schema is almost 1T. Please help ASAP. ORA-39083: Object type TYPE failed to create with error: ...
or if it needs to be rectify whats steps need to be perform if i don't want to reimport back. Please help i need a solution for this as the schema is almost 1T. Please help ASAP. ORA-39083: Object type TYPE failed to create with error: ...