Books for you

For instance, you could make a change to data that would be
visible to workspace users for the next 24 hours and that would then disappear.
Workspaces have their own locking mechanisms that apply only to other workspace
users. You can exclusively lock a row of data in a workspace, but this lock prevents
access only to that row for other workspace users. The underlying data could still be
accessed or changed by users who are not part of the workspace. This additional
locking makes sense, since both locks and workspaces are meant to isolate data from
changes. A workspace exists outside the boundaries of the standard database, so
workspace locks and standard database locks do not directly interact.
200 | Chapter 8: Oracle Multiuser Concurrency
Workspace Operations
There are three basic operations that apply to workspaces:
Rollback
Youcan roll back changes to a workspace to return the workspace to the point
in time when the workspace was created. Youcan also designate savepoints,
which allow you to roll back the changes in a workspace to a subsequent point
in time.


Pages:
422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446