-- 重新编译单个存储过程 ALTER PROCEDURE my_procedure COMPILE; -- 重新编译所有无效的存储过程 SELECT 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;' FROM USER_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PROCEDURE'; 自动重新编译脚本示例: 代码语言:txt 复制 DECLARE v_sql VARCHAR2(4...
1. 如果对象是因为编译报错失效的,可以用以下sql查出 select object_name, status, last_ddl_time, e.line, e.text from dba_objects d, dba_errors e where d.status = 'INVALID' and d.OBJECT_NAME = e.name and d.object_type = e.type and d.owner = e.owner 1. 2. 3. 4. 5. 6. 2....
--对存储过程依赖的表进行修改,过程状态变为invalid select * from user_objects u where u.OBJECT_TYPE='PROCEDURE' AND U.OBJECT_NAME='PROC_JIFEN_CX' / --存储过程状态为invalid,编译存储过程,状态变为valid,last_ddl_time和timestamp都改为最新的 ---远程数据库调用执行报错ORA-04062: timestamp of pro...
from dba_objects where status='INVALID' and owner='SYS';OWNEROBJECT_NAMEOBJECT_TYPECREATEDLAST_DDL_TIMESTATUS---SYSALL_TAB_STATISTICSVIEW2011-09-172012-05-16INVALIDSYSUSER_TAB_STATISTICSVIEW2011-09-172012-05-16INVALIDSYSALL_IND_STATISTICSVIEW2011-09-172012-05-16INVALIDSYSUSER_IND_STATISTICSVIEW201...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
5 status 6 from dba_objects where status='INVALID' and owner='SYS'; no rows selected 方法3: [javascript] view plain copy 以下是一个转帖的方法 [javascript] view plain copy --创建自动编译失效过程事务记录表 declare tabcnt integer := 0; ...
col statusfora8 selectowner, object_name, object_type, status fromdba_objects wherestatus='INVALID' orderby1, 2,3; 下文大多参考博文Oracle中编译无效的对象常用方法,修改并作了总结、整理 1:使用ALTER *** COMPLIE语句手工进行编译,这个适用于少数、个别对象失效 ...
select owner,object_name,object_type from dba_objects o where status = 'INVALID' and owner = 'GZDQMP' and o.OBJECT_TYPE='VIEW';解决是重新编译。ORA-04065:未执行,已更改或删除stored procedureXXX(过程名)错误说明:同一个过程中调用了多过程,先跑的过程中有DROP表后重建的操作,DROP表的操作导致后...
select tablespace_name,status from dba_tablespaces; 说明:输出结果中“STATUS”应该都为“AVAILABLE”。 (4)数据库在线日志检查 select group#,status,type,member from v$logfile; 说明:输出结果应该有3条或3条以上记录,“STATUS”应该为非“INVALID”,非“DELETED”。“STATUS”的值为空表示正常。
SQL> select owner,object_name,object_type,status from dba_objects where object_name=''---status = 'INVALID'; http://blog.itpub.net/31536355/viewspace-2691001/ 结果依旧失效: 查看触发器内容: 1)使用trigge_body查询触发器内容,返回的是Long类型 select...