Providing multi-version databases for backward compatibility for production applications/databases [closed]

Closed. This question needs to be more focused. It is not currently accepting answers.

---

Want to improve this question? Update the question so it focuses on one problem only by editing this post.

Closed 5 years ago.

Improve this 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开发者_如何学Go 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.

---

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.