--编译所有无效PROCEDURE对象BEGIN FOR cur IN ( SELECT object_name ,object_type FROM dba_objects WHERE object_type = 'PROCEDURE' AND status = 'INVALID' ) LOOP DBMS_OUTPUT.PUT_LINE(cur.object_name); EXECUTE IMMEDIATE 'ALTER ' || cur.object_type || ' ' || cur.object_name || ' COMPILE...
使用Oracle的数据字典视图,如DBA_OBJECTS或ALL_OBJECTS,来查找无效对象。这些视图包含数据库中所有对象的信息,包括对象的状态(是否有效)。 以下是一个示例查询,用于查找所有类型的无效对象: sql SELECT object_name, object_type, status FROM dba_objects WHERE status = 'INVALID'; 这个查询将返回数据库中所有状态...
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...
SELECT owner, object_name, object_type,status FROM dba_objects WHERE status = 'INVALID'; 2、检查不起作用的约束: SELECT owner, constraint_name, table_name, constraint_type, status FROM dba_constraints WHERE status = 'DISABLED'; 3、检查无效的触发器: SELECT owner, trigger_name, table_name, s...
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表的操作...
SQL> select * from dba_objects t where t.status = 'INVALID' order by 1; 1. 2.编译无效对象 select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects t where t.status = 'INVALID' order by 1; ...
HKJJW TEST VIEW 2013-08-02 2013-08-02 INVALID 指定查询某用户无效对象。 SQL> select * from dba_objects where status<>'VALID' and owner='HKJJW'; 2. 手动执行编译或 ALTER FUNCTION HKJJW.FUNC_RETURN_PY COMPILE; ALTER VIEW HKJJW.MONITORING_FLOW_PARALLEL_VIEW COMPILE; ...
SQL>selectowner,object_name,object_typefromdba_objectswherestatus='INVALID';1.2、修正无效的对象编译对象SQL>alterprocedureADD_NUMScompile;Procedurealtered.如果编译成功,就不存在问题,如果编译失败,就需要找出失败的原因。SQL>showerrors如果希望确定编译错误的原因,通常需要首先使用DBA_DEPENDENCIES视图。SQL>descdba_...
ORA-65005: missing or invalid file name pattern for file-/u01/app/oracle/oradata/ORA19C/pdb1/system01.dbf 解决方法:路径错误或注意路径中的大小写。 错误五: ORA-01578: ORACLE data block corrupted (file # 72, block # 33609) ORA-01110: data file 72: '/u01/app/oracle/oradata/ORA19C/pd...
ORA-12170:TNS:Connect timeout occurred，说明CPSETL.BI_FEED_CUSTOMER_SNAPSHOT里有远程dblink涉及，需要具体诊断该远程dblink访问问题。