Recompilation of all triggers in a schema.
484123Aug 23 2006 — edited Aug 23 2006Hi folks!
I got a gotcha!
I'd changed couple of table structures here and there in the schema and subsequently, quite understandably, all the triggers that are related to the afore-altered tables went into invalid status.
It is taking a toll on me to again recompile each and every trigger in the schema.
How do I recompile all the triggers in the entire schema with the help of a single statement?
Your favour'll be deeply appreciated.
Cheers, PCZ.