--编译程序包 ALTER PACKAGE package_name COMPILE; ---分别编译程序包PACKAGE和BODY ALTER PACKAGE package_name COMPILE PACKAGE; ALTER PACKAGE package_name COMPILE BODY; --编译视图和触发器 ALTER VIEW <SCHEMA NAME>.<VIEW_NAME> COMPILE; ALTER TRIGGER <SCHEMA).<TRIGGER_NAME> COMPILE; --查看是否有编...
Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
1)创建脚本reCompile.sql AI检测代码解析 set heading off; set feedback off; set echo off; Set lines 999; Spool run_invalid.sql select 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;' from dba_objects where status = 'INVALID' and OWNER = 'APPS' ...
-- 重新编译单个存储过程 ALTER PROCEDURE my_procedure COMPILE; -- 重新编译所有无效的存储过程 SELECT 'ALTER PROCEDURE ' || OBJECT_NAME || ' COMPILE;' FROM USER_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PROCEDURE'; 自动重新编译脚本示例: ...
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 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 : In sqlplus connect as sys: set heading off spool compileinvalid.sql ...
在同一个数据库内,被引用对象上进行了alter、drop等操作,该对象的依赖对象如view、function、procedure等,状态会自动标记为Invalid,再重新使用这些依赖对象时,系统会自动重新compile。 而一个数据库内的对象引用了远程数据库的对象(这里指程序对象,如procedure等),则远程数据库对象发生了变更,由于本地数据库并不知晓此...
01.create or replace procedure compile_invalid_procedures( 02. p_owner varchar2 -- 所有者名称,即 SCHEMA 03.) as 04. 05.--编译某个用户下的无效存储过程 06. 07. str_sql varchar2(200); 08. 09.begin 10. for invalid_procedures in (select object_name from all_objects ...
DOC> utlirp.sql completed successfully. All PL/SQL objects in theDOC> database have been invalidated.DOC>DOC> Shut down and restart the database in normal mode and run utlrp.sql toDOC> recompile invalid objects.DOC>###也就是说,这个脚本的作用是使数据库中的PL/SQL对象INVALID,然后通过utlrp....