Providing multi-version databases for backward compatibility for production applications/databases.

Question

How can I manage multiple versions of a database easily?

I have some data (as views as selects for data originating in tables from other schemas), which other database may reference using various means including database synonyms & links.

I wish to provide a sort of interface/guarantee in-case future for applications/databases which use this data. All of this is for in the event i need to update the views for correctness or applicability inside my database.

How can i achieve this in a maintained, controlled and easy way?

I am using Oracle 10g if that matters.

Answer 1

Hi JavaRocky,

Have a look at the 11gR2 feature: Edition-Based Redefinition. It allows you to have multiple versions of views and packages available in the database.

You can read more in a Christian Antognini's paper.