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?????