Fairly simple question.
Ive a need to compile/recomplile all pl/sql packages under a single user in Oracle 8. How can I do it.
I know I can extract out each package name etc, and create a file of compile <package>
but is there a command that when issued, will go away for a few hours and compile all packages/pocedures
compile all_packages <user>