QUESTION POSED ON: 29 November 2005
We are developing a large application base on PL/SQL. We often have to
change DB objects, e.g., add a new column to a table or
grant/revoke some privileges from/to some objects (things like
tables, triggers, tablespaces, synonyms and so on).
The biggest trouble comes with every new release. To enhance our
application we have to know about the latest state of all DB objects. To
find this out, we have to run through the history of all PL/SQL files.
There must be a better way to solve this problem. We want something
like "export all objects" so we get a lot of SQL files that contain the
definitions of all objects. We take these files and put them into our new
DB, so we have the latest state of the DB (without running through the
history).
|