OracleDatabase11g Enterprise Edition Release11.2.0.1.0-64bitProductionWiththe Partitioning, OLAP, Data MiningandRealApplication Testing optionsCREATEORREPLACEPROCEDURERAISESALARY(PNAMEINVARCHAR2(20))2AS3psssal TESTDELETE.TESTID%TYPE;4BEGIN5SELECTTESTIDINTOpsssalFROMTESTDELETEWHERETESTNAME=PNAME;UPDATETESTDE...
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数据库中的目录对象是否存在 首先,需要确认数据库中是否存在你试图访问的目录...
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: ORA-02304: invalid object identifier literal ...
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; ...
--生成手动编译无效对象的脚本,然后执行脚本。SELECT'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'FROMDBA_OBJECTSWHERESTATUS='INVALID'ANDOBJECT_TYPEIN('PACKAGE','PACKAGE BODY','FUNCTION','PROCEDURE','TRIGGER','VIEW','SYNONYM','JAVA SOURCE','JAVA CLASS'); ...
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>SELECT*FROMDBA_OBJECTSWHEREOBJECT_NAMELIKE'WM_CONCAT%'; 解决办法有两种,一种是采用Oracle本身的脚本来创建WM_CONCAT函数,一种是采用自己创建的函数来解决这个问题。 1、用Oracle自带脚本重建WMSYS用户的WMSYS.WM_CONCAT函数 运行如下脚本卸载WMSYS用户的数据: ...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
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