二.编写拼接SQL编译 编写拼接sql 来批量手动编译 select'ALTER '||OBJECT_TYPE||' '||OWNER||'.'||OBJECT_NAME||' COMPILE;'fromdba_objectswherestatus='INVALID'; 三.存储过程+调度任务定时编译 – 编译失效对象的存储过程 CREATEORREPLACEPROCEDUREcompile_all_invalid_objectsASBEGINFORobjIN(SELECTobject_name...
<VIEW_NAME> COMPILE; ALTER TRIGGER <SCHEMA).<TRIGGER_NAME> COMPILE; --查看是否有编译错误 show errors PL/SQL生成脚本编译所有无效用户对象 例1: 代码语言:javascript 代码运行次数:0 运行 AI代码解释 --编译所有无效PROCEDURE对象BEGIN FOR cur IN ( SELECT object_name ,object_type FROM dba_objects ...
In case you have lots of invalid objects,you can generate scripts that will generate the sqls for compiling the invalid objects : In sqlplus connect as sys: set heading off spool compileinvalid.sql select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from...
In case you have lots of invalid objects,you can generate scripts that will generate the sqls for compiling the invalid objects : In sqlplus connect as sys: set heading off spool compileinvalid.sql select 'alter '||object_type|| ' ' || owner ||'.'||object_name || ' compile;' from...
FROM dba_objects WHERE status = 'INVALID' ORDER BY owner, object_type, object_name; 1. 2. 3. 4. 5. 6. 7. 8. 少量直接alter, 注意包体需要加body AI检测代码解析 ALTER PACKAGE my_package COMPILE; ALTER PACKAGE my_package COMPILE BODY; ...
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; ...
Compile all invalid objects. Validate that the system is ready for cutover. If finalize_mode=full, compute statistics for key data dictionary tables for improved performance. Run the finalize phase as follows: $ adop phase=finalize Online Patching Cycle Steps - Cutover Phase ...
也就是说,这个脚本的作用是使数据库中的PL/SQL对象INVALID,然后通过utlrp.sql的重新编译,消除跨平台的兼容性影响。按照transport.sql脚本提示的步骤,我们可以重新启动数据库来执行utlrp.sql脚本(由于本例涉及到版本迁移,需要再次启动数据库到UPGRADE模式,如果数据库版本相同,则可以直接启动数据库,执行utlrp.sql脚本完成...
3.select 'alter procedure '||object_name||' compile;' from all_objects 4.where status = 'INVALID' and object_type = 'PROCEDURE' AND owner='UNMI'; 5. 6.spool off 7. 8.@ExecCompProc.sql; 2. 写成一个存储过程 -- 让这个存储过程在某个时机执行,比如 Job 中,代码如下: ...
用于运行桌面应用程序的 Java 面向使用台式机和笔记本电脑的最终用户 下载适用于台式机的 Java Java 是什么 最终用户帮助 开发人员和企业管理员 来自Java 管理者 Oracle 的免费 Java 开发工具包 (JDK) 下载和资源 开发人员下载 开发人员资源 企业资源 OpenJDK 抢先体验版...