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

Posted by JavaRocky on Stack Overflow See other posts from Stack Overflow or by JavaRocky
Published on 2010-03-18T12:54:28Z Indexed on 2010/03/18 13:31 UTC
Read the original article Hit count: 350

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.

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about database