Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Workspace Manager question

Re: Workspace Manager question

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Thu, 03 Feb 2005 00:50:10 GMT
Message-Id: <pan.2005.02.03.00.48.08.902692@gmail.com>


On Wed, 02 Feb 2005 18:50:17 -0500, NowhereMan wrote:

> Hello,
>
> I'm reading the "Oracle Workspace Manager Dev Guide", and came across this:
>
> "A workspace logically groups collections of
> new row versions from one or more version-enabled tables, and isolates these
> versions until they are explicitly merged with production data or discarded,
> thus
> providing maximum concurrency."
>
> Can someone help me understand how a workspace could have rows from more
> than one table? How would the workspace get populated?
>
> Thanks for any insight...

Create a schema with one table, fire up Oracle Enterprise Manager 9i, create a workspace and enable the table in the workspace. Look at the resulting schema.

You will find that the table gets replaced by a view that maps to the table. With the addition of a few columns and supporting info, you can now simulate a table that supports 'named versions' of rows. With a few added packages you can now simulate commits, rollbacks, etc. for transactions that persist across logoffs

lol/FGB Received on Wed Feb 02 2005 - 18:50:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US