Originally posted by marist89
?/rdbms/admin/utlrp.sql - compiles all packages
?/rdbms/admin/utlirp.sql - makes everything invalid
Yeah, I'm guessing that he was concerned about invalid triggers essentially. The utlrp would then forcibly make it valid afterwards, even if someone had explicitly had them down as "invalid" before.