RE: Anyone storing their documents in the database with

To answer Arn's question, no, I'm not currently using it. However I can see some potential in the product.

Rich, Workspace management allows you to "version" a table. You can create multiple "versions" of the same table (workspaces), and different people can work in different workspaces and multiple people can work in the same workspace. Change made in one workspace can not be seen in another workspace.

As an example say that I have a nightly update program create a workspace on my tables and perform less than atomic level updates (e.g. commits within PL/SQL loops for example) while the data to the user would look perfectly consistent. When the update is done, all I need do is merge the workspace with the live workspace.

As you might expect, there are space considerations to using workspace, to weigh against the benefits. I don't recall if it's a 1:1 space requirement or not.

RF

Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com!

-----Original Message-----
Sent: Wednesday, January 22, 2003 11:20 AM To: Multiple recipients of list ORACLE-L

Better yet -- WHAT is Workspace Management?

"Additional training for Oracle 9i" -- Goals for 2003 :)

> -----Original Message-----
> From: Arn Klammer [mailto:Arn.Klammer_at_austrac.gov.au]
> Sent: Tuesday, January 21, 2003 12:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Anyone storing their documents in the database with
>
>
> Robert,
>
> Does this mean you're using it? If so, could you describe
> your use, and any caveats?
>
> >>> robertgfreeman_at_yahoo.com 21/1/2003 15:28:47 >>>
> This message has been scanned by MAILSweeper.
> ************************************************************
>
> Workspace management - cool feature!
>
> RF

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).