Atropa
asked on
What is a "versioned table"?
Could someone tell what a versioned table is/does? I just have never come across this in all my years around databases etc. Is this something that MS SQL Server (where all my experiance comes from, big surprise eh?) does not offer and yet another reason why Oracle is so much more better gooderer than MS SQL?
Thnx for your help in advance...a
Thnx for your help in advance...a
ASKER
Umm, thnx(?). Remember I said I am a MS SQL type person so you lost me once you said "Versions relationsal content in place with no changes to application SQL"
So is another "copy" of the table made and the old one stored as a temp table so you can roll back changes at a latter date? Is it like Begin / Commit Transaction on major steroids? Is there ever a problem with not having the current "version" of a table?
What if two apps "version" a table at close to / at the same time? How are your certain to get the current version? Am I on the right track with these questions?
So is another "copy" of the table made and the old one stored as a temp table so you can roll back changes at a latter date? Is it like Begin / Commit Transaction on major steroids? Is there ever a problem with not having the current "version" of a table?
What if two apps "version" a table at close to / at the same time? How are your certain to get the current version? Am I on the right track with these questions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you both for the details. That is an awesome feature for sure and I can definately see where the benefit comes from. Thanks again...a
Oracle9i Workspace Manager is a new feature of Oracle9i that transparently and securely versions relational content in place with no changes to application SQL (DML), while permitting simultaneous read and write access to the same production data.
References:
===========
Subject: Frequently Asked Questions for Oracle Workspace Manager
Doc ID: Note:156963.1
Subject: What's the impact of Enabling Version Support?
Doc ID: Note:197188.1