Triggers

[hummy]

anyone know what kind of script I can run in through SQL plus to compile all triggers within a database. I know how to compile a trigger individually 'ALTER TRIGGER XXX COMPILE' however I need an esay way to compile over 300 triggers. any ideas?????

[markmd]

try this :

set heading off
set pagesize 0
set feedback off

spool xyz.sql

select 'alter trigger '||trigger_name||' compile;'
from user_triggers;

spool off

@xyz.sql

[kris109]

Try this:

set heading off;
set feedback on;
set pages 10000;

spool &&spoolfile

select 'alter '||object_type, object_name
||' compile;'
from user_objects
where object_type = 'TRIGGER'

spool off

@&&spoolfile

host del &&spoolfile

undefine spoolfile;