compile_schema(schema => 'SCOTT', compile_all => false); UTL_RECOMP包编译数据库失效对象 UTL_RECOMP包中包含两个用于重新编译无效对象的过程。 RECOMP_SERIAL过程一次重新编译所有无效对象,而RECOMP_PARALLEL过程使用指定数量的线程并行执行相同的任务。 例: 代码语言:javascript 代码运行次数:0 运行 AI...
The following PL/SQL block invokes UTL_RECOMP to recompile invalid objects in the database. Recompilation time is proportional to the number of invalid objects in the database, so this command may take a long time to execute on a database with a large number of invalid objects. Use the ...
SELECT object_name, object_type, status FROM user_objects WHERE status = 'INVALID'; 复制代码 重新编译失效的对象:对于每个失效的对象,可以使用ALTER语句重新编译它。例如,如果有一个名为my_procedure的失效存储过程,可以使用以下命令重新编译它: ALTER PROCEDURE my_procedure COMPILE; 复制代码 如果有多个失效的...
https://oracle-base.com/articles/misc/recompiling-invalid-schema-objectsRecompilingInvalidSchemaObjectsOracleオブジェクトを一括で再コンパイルする方法https://www.saka-en.com/oracle/oracle-recompile-bulk/ 复制
The following PL/SQL block invokes UTL_RECOMP to recompile invalid objects in the database. Recompilation time is proportional to the number of invalid objects in the database, so this command may take a long time to execute on a database with a large number of invalid objects. ...
SQL> @C:UsersAdministratorDesktopaq eCompile.sql; 备注:运行脚本reCompile.sql的时候,会创建另一个脚本run_invalid, 紧跟着执行该脚本,完成编译工作 1. 2. 3. 4. 5. 5 编写PL/SQL利用游标编译 declare v_object_name user_objects.object_name%type; ...
Invalid SYS objects cannot be recompiled.The issue started with an alert log messages: ORA-04063: package body "SYS.DBMS_SQLTUNE" has errors ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SQLTUNE".When the DBA tried to recompile this package body (as sysdba), ...
-- 重新编译单个存储过程 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...
SELECT object_type, object_name, status FROM user_objects WHERE status = 'INVALID'; 复制代码 对于每个无效对象,使用ALTER语句重新编译它们。例如,如果有一个名为my_procedure的无效存储过程,请运行以下命令: ALTER PROCEDURE my_procedure COMPILE; 复制代码 更新应用程序代码:根据需要更新应用程序代码以确保与新...
闪回恢复区大小:2048 MB。 重新编译无效对象:选择 Recompile invalid objects at the end of upgrade。 摘要:单击 Finish。 图4 图5 进度:单击 OK 查看升级结果。 升级结果:单击 Close。 SQL> select comp_name,version,status from dba_registry; COMP_NAME VERSION STATUS --- --- --- Oracle...