1、compile_all_bodies.sql SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER PACKAGE ' || a.owner || '.' || a.object_name || ' ...
转载
2021-08-24 15:33:00
241阅读
2评论
查看当前无效对象
select *
from dba_objects t
where t.status = 'INVALID' order by 1;
编译无效对象：
有两种方式：
1、执行sql查询结果：
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;'
from dba_objec
原创
2021-09-16 14:52:57
7354阅读
每天一个 DBA 小知识，助你更进一步！
原创
2022-02-08 16:34:49
478阅读
查询无效对象：
col owner format a15;
col OBJECT_NAME format a30;
select owner,object_name from dba_objects
where status = 'INVALID';
手动编译无效对象：
alter procedure/view object_name compile;
编译全部无效对象：
$ORA
原创
2013-02-17 14:26:31
442阅读
查询无效对象SQL: SELECT COUNT (*) FROM user_objects WHERE object_type IN ('PROCEDURE','FUNCTION','TRIGGER','VIEW','PACKAGE') AND stat
转载
精选
2012-11-15 22:36:28
1544阅读
编译无效对象 1、查找无效对象： SELECT object_name, object_type FROM dba_objects WHERE status = 'INVALID'; 2、编译无效对象： 手工编译： ALTER PACKAGE pkg1 COMPILE REUSE SETTINGS;使用PL/SQL Package编译 : revalidate all invalid objects in the database, in parallel and in dependency order: begin utl_recomp.recomp_parallel();
转载
2013-06-19 20:02:00
111阅读
oracle 编译无效对象1.手动编译如果无效对象的数量很少,那么你可以逐个编译这些对象.如ALTER PACKAGE my_package COMPILE;ALTER PACKAGE my_package COMPILE BODY;ALTER PROCEDURE my_procedure COMPILE;ALTER FUNCTION my_function COMPILE;A...
转载
2022-04-11 15:28:51
1220阅读
oracle 编译无效对象1.手动编译如果无效对象的数量很少,那么你可以逐个编译这些对象.如ALTER PACKAGE my_package COMPILE;ALTER PACKAGE my_package COMPILE BODY;ALTER PROCEDURE my_procedure COMPILE;ALTER FUNCTION my_function COMPILE;A...
转载
2021-08-09 22:46:33
571阅读
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can occur on any platform. Symptoms: The issue is that the following error was raised : ORA-00600: internal error code, arguments: [kesutlGetBindValue-2], [], [], [], [], [], [], [] The recent changes was the : Migrati
转载
2009-11-20 18:45:00
106阅读
2评论
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can occur on any platform. Symptoms:
转载
2009-11-20 18:45:00
37阅读
2评论
ORACLE批量编译无效对象
原创
2010-12-09 10:29:03
1387阅读
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can occur on any platform. Symptoms:
原创
2022-01-06 13:55:26
196阅读
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can occur on any platform. Symptoms: The issue is that the following error was raised : ORA-00600: internal error code, arguments: [kesutlGetBindValue-2], [], [], [], [], [], [], [] The recent changes was the : Migrati
转载
2009-11-20 18:45:00
84阅读
2评论
编译无效对象之各种小方法
原创
2013-12-06 15:53:46
7695阅读
在采用IMPDP/IMP工具迁移数据时，经常会提示无效对象的警告，需要采用如下方式处理。1. 查询指定用户的无效对象su – oraclesqlplus / as sysdbaSQL> select owner,object_name,replace(object_type,' ','') object_type,to_char(created,'yyyy-mm-dd') as create
原创
2014-11-25 21:42:53
1213阅读
点赞
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can occur on any platform. Sy
转载
2009-11-20 18:45:00
58阅读
2评论
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.5.0 This problem can ocerror was raised : ORA-00600: internal error cod
原创
2022-09-01 22:13:27
192阅读
在数据库中，会存在一些无效的对象，导致这种现象的发生原因很多，其中最常见的就是数据库升级(例如修改了表的结构)，迁移而引起。编译无效对象的方式：1 使用alter **** compile 语句进行编译 alter function function_name compile;alter package package)name compile;a
转载
2022-10-29 00:13:34
1731阅读
1.查看无线对象 SQL> select * from dba_objects t where t.status = 'INVALID' order by 1;2.编译无效对象 select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects t wher
原创
2022-08-05 12:20:31
363阅读
无效和不可用对象 无效 PL/SQL 对象和不可用索引会对性能产生影响。无效 PL/SQL 对象必须先进行重编译，然后才能使用。这需要在执行尝试访问 PL/SQL 程序包、过程或函数的第一个操作之前花费一段编译时间。如果 PL/SQL 重编译未成功，则操作会因发生错误而失败。优化程序会忽略不可用索引。如果 SQL 语句性能的好坏取决于已标记为不可用的索引，则
