select
decode(OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER || '.' || OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' compile;')
--from dba_objects
from all_objects
where STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW')
order by OBJECT_TYPE,
OBJECT_NAME;
prompt ===================编译无效对象脚本=====================
prompt --查看无效对象
select
object_name,
object_type,
owner
--from dba_objects
from all_objects
where status != 'VALID'
order by OBJECT_TYPE,
OBJECT_NAME;
set heading off
set pagesize 0
set verify off
set echo off
spool complie_objects.sql
select
decode(OBJECT_TYPE, 'PACKAGE BODY',
'alter package ' || OWNER || '.' || OBJECT_NAME || ' compile body;',
'alter ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' compile;')
--from dba_objects
from all_objects
where STATUS = 'INVALID' and
OBJECT_TYPE in ( 'PACKAGE BODY', 'PACKAGE', 'FUNCTION', 'PROCEDURE', 'TRIGGER', 'VIEW')
order by OBJECT_TYPE,
OBJECT_NAME;
spool off
spool compile_objects.log
@complie_objects.sql
spool off
重编译数据库invalid代码
最新推荐文章于 2024-09-03 14:39:33 发布