-- 重新编译单个存储过程 ALTER PROCEDURE my_procedure COMPILE; -- 重新编译所有无效的存储过程 SELECT 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;' FROM USER_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PROCEDURE'; 自动重新编译脚本示例: ...
错误说明:视图的状态为INVALID。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(过程名) 错误说明:同一个过程中调用了多过程,先跑的过程中有DRO...
错误说明:视图的状态为INVALID。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表后重...
@run_invalid.sql SQL 2:在上面的方法中,只能知道某某编译失败,不清楚失败原因,可以用PL/SQL实现更详细的错误信息 DECLARE v_objname user_objects.object_name%TYPE; v_objtype user_objects.object_type%TYPE; CURSORcurIS SELECTobject_name,object_type FROMUSER_OBJECTS WHEREstatus ='INVALID' ANDobject_type...
FROM USER_OBJECTS WHERE STATUS='INVALID'; 1. 2. 3. utlrp.sql脚本 执行@$ORACLE_HOME/rdbms/admin/utlrp.sql脚本编译数据库失效对象。 数据库的升级迁移等操作可能会导致数据库中大量对象失效,由于对象间可能存在复杂的依赖关系,手工编译通常无法顺利通过。Oracle强烈建议在升级迁移后,运行此脚本编译失效对象。utl...
如果发现不匹配,则会直接报错返回,同时将依赖该远程对象的所有本地对象标记为invalid。 二、测试存储过程的last_ddl_time和timestamp何时发生变化 select * from user_objects u where u.OBJECT_TYPE='PROCEDURE' AND U.OBJECT_NAME='PROC_JIFEN_CX' OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT...
v_object_name user_objects.object_name%type; v_object_type user_objects.object_type%type; cursor cur is select t.object_name, t.object_type from user_objects t where t.status = 'INVALID' --and t.object_name like 'CUX%' and t.object_type in ('PROCEDURE', ...
2-14 Oracle Fusion Middleware User's Guide for Oracle Business Activity Monitoring Getting Started With Oracle BAM Administrator Figure 2â13 Oracle BAM Architect User Interface Oracle BAM Architect provides access to the Data Objects, Enterprise Message Sources (EMS), External Data Sources (...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。
12-34 12.34.1 Property Names Containing '.' Characters Are Not Supported by loadProperties 12-34 12.34.2 Invalid cachedir Created by Jython Causes WLST to Error Out ... 12-35 12.34.3 WLST returnType='a' Option Returns Child Management Objects ... 12-35 12.35 Web Server Plug-Ins Issues...