--修改依赖表的表结构,package body状态为invalid,package状态为valid,远程数据库调用包执行正常,且执行过后package body已编译通过状态为valid,last_ddl_time和timestamp都已修改为当前时间 OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS PKG_JIFEN_CX_SE...
看到有package body呀 ，再看具体的这个名字对应的类型：SQL> SELECT owner,object_type,object_name ...
解决是加内存或者降低并发 ORA-04063:view “GZDQMP.V_VIEW_NAME” has errors或者package body ‘…’ has errors等等 错误说明:视图的状态为INVALID。select owner,object_name,object_type from dba_objects o where status = ‘INVALID’ and owner = ‘GZDQMP’ and o.OBJECT_TYPE=’VIEW’;解决是重新编...
Oracle0文件是上一个版本oracle文件的备份,确认了之前升级失败导致。 8. 11.2.0.4 迁移PL/SQL package一个很平常的操作,居然在导入后package body总是invalid, 导入过程中corrupted, 后分析原来是时wraped PL/SQL中如果首尾出现“/”符号,会出来这个问题是当前版本的BUG。 9. 平时一个很平常的RMAN备份还原迁移,结...
如果是package body alter package DBMS_CUBE compile body; 3. 自动生成编译无效对象SQL 1) 统计当前用户无效对象数量: SQL> select owner,object_type,status,count(*) from dba_objects where status='INVALID' group by owner,object_type,status order by owner,object_type; ...
Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you can generate scripts that will generate the sqls for compiling the invalid objects : ...
select 'ALTER PACKAGE ' || OWNER||'.'|| OBJECT_NAME || ' COMPILE body;' from ALL_objects where status = 'INVALID' and object_type in ('PACKAGE BODY'); SELECT UNIQUE OBJECT_TYPE FROM ALL_OBJECTS; 2. Verify that the status of the CATPROC : ...
ORA-04061: existing state of package body "APPS.<some package>" has been invalidated ORA-04065: not executed, altered or dropped package body... I've recompiled the package/body, cleared the share pool, etc., but the error persists. There is no invalid object in dba_objects either. ...
When the DBA tried to recompile this package body (as sysdba), it complained that a number of sys views were invalid.When DBA checked, it was found that many SYS views were invalid, particularly those starting with DBA_HIST_.DBA tried running utlrp, but it did not acknowledge that any ...
where status = 'INVALID' and OWNER = 'APPS' and object_type in ('PACKAGE BODY'); spool off; set heading on; set feedback on; set echo on; @run_invalid 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15.