UT派，都说要。
 
用以下命令检查。
select ‘alter ‘||decode(substr(object_type,1,7),’PACKAGE’,’PACKAGE’, object_type)||’ ‘||object_name ||’ compile ‘|| decode(substr(object_type,1,7),’PACKAGE’,’body;’,’;’) from user_objects where status=’INVALID’ and object_type<>’TYPE BODY’
再用输出结果recompile.
 
 
OP派，说不用，oracle自己会搞定。
 
The views in question reference PL/SQL functions, which are loaded the last by the IMP utility.
It won’t hurt to recompile the invalid objects, though it’s not strictly necessary (as Oracle always attempts recompilation of an invalid object on first access). There is a standard Oracle script for that purpose (%oracle_home%\rdbms\admin\utlrp.sql on the database server).
 
Â