在用impdp导入时,如果报编译错误,如:ORA-39082: Object type ALTER_PROCEDURE:"CONTA"."PROC_CONTA_BALANCE_FZHKH" created with compilation warnings,可以用如下方法解决:
sys用户查看无效对象:
col object_name for a30;
select owner,object_name,object_type,status
from dba_objects
where status !='VALID'
and owner not in ('SYS','SYSTEM')
/
编译无效对象:
view: alter view view_name compile;
function: alter function function_name compile;
procedure: alter procedure procedure_name compile;
show error 的用法:
编译view出现问题:
alter view view_name compile;
Warning:view view_name with compilation errors.
SQL>show errors view view_name
Errors for view view_name:
LINE/COL ERROR
----------- -------------------------
0/0 ORA---
参考:http://blog.csdn.net/sunjiapeng/article/details/19017781
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28916011/viewspace-2142172/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/28916011/viewspace-2142172/