Bulk upload stored procedures to multiple Oracle user schemas

Question

Oracle

Introductory: there are a dozen test and the same number of production schemes for Oracle 11g users. Every few days, for two dozen schemes, you have to upload business logic updates so that the set of packages and HP is the same everywhere.

Now this task is solved by a self-written script that looks at the contents of the folder and executes through SQLPlus all files with *.sql, *.fnc, *trg, *.prc, *.pks, *pkb extensions for different sets of username/[email protected], then it recompiles each schema and generates a final protocol with a report on invalid objects.

Perhaps someone before me came up with a more elegant solution to the problem? If yes, please share your experience.

Answer 1

What's wrong with the current solution? Well, you can fasten Ant or another deployment tool.