导入数据后编译所有对象的脚本
connect user/passWord@connectstr
set head off
set pagesize 0
set feedback off
spool temp.sql
select 'ALTER 'object_type' 'object_name' compile;' from user_objects where object_type in ('VIEW','TRIGGER','PROCEDURE','FUNCTION','PACKAGE','PACKAGE BODY');
spool off
@temp.sql
/
