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 /
