/*-----------------------------------------------------------*/
/* This program assumes you are logged in as the */
/* owner of the tables with triggers associed with */
/* them. This is important,since DBA privilegeed */
/* users may experience problems compiling other */
/* user's code. */
/*-----------------------------------------------------------*/
set pages 0 feed off echo off trimsp on
spool e:\bak_db\compile.sql
prompt spool e:\bak_db\result_complile.sql
prompt set echo on feed on
prompt --trigger
select 'alter trigger '|| trigger_name || ' compile;'
from user_triggers;
prompt --trigger
select 'alter view '|| view_name || ' compile;'
from user_views;
prompt --package
select distinct 'alter ' || type || ' ' || name || ' compile;'
from user_source
where type <>'PACKAGE BODY';
prompt spool off
spool off