重庆思庄Oracle、Redhat认证学习论坛

标题: 生成编译无效PACKAGE BODY的语句 [打印本页]

作者: 郑全 时间: 2023-1-10 18:16
标题: 生成编译无效PACKAGE BODY的语句
select 'alter PACKAGE ' || owner || '.' || object_name || ' compile body;' comp_stat from dba_objects where status<>'VALID' and object_type='PACKAGE BODY' order by 1;

COMP_STAT
--------------------------------------------------------------------------------
alter PACKAGE SYSMAN.EM_FLAT_COMPTGT compile body;
alter PACKAGE SYSMAN.MGMT_ECM_POLICY compile body;

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)