SELECT 'ALTER PACKAGE '||do.owner||'.'||do.object_name|| ' COMPILE BODY ;'
FROM dba_objects do WHERE do.object_name LIKE '%' AND do.status='INVALID' AND do.object_type='PACKAGE BODY';
2.编译PACKAGE
ALTER PACKAGE APPS.HSS_API COMPILE PACKAGE ;
3.编译PACKAGE SPECIFICATION
ALTER PACKAGE APPS.HSS_API COMPILE SPECIFICATION ;
4.编译PACKAGE BODY
ALTER PACKAGE APPS.HSS_API COMPILE BODY ;
四.编译无效视图
1.查找无效视图
SELECT 'ALTER VIEW '||do.owner||'.'||do.object_name|| ' COMPILE;'
FROM dba_objects do WHERE do.object_name LIKE '%' AND do.status='INVALID' AND do.object_type='VIEW';
2。编译视图
ALTER VIEW APPS.FA_ASSET_HISTORY_V COMPILE;
posted on
2013-12-19 11:46王小航
阅读(955)
评论(0)
编辑收藏举报
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步