![]() ![]() The Row History use case is similar to using Flashback Query which is a more modern feature of the database however, since it can be enabled or disabled individually for each table, it may require less storage space to support querying back as far as the user would like in time. Valid Time – support date/time range validity for each record.Row History – store a history of every change for every record.Workspaces – a private area for modifications that are not visible to normal users.Savepoints – a snapshot of a point in time.OWM allows the developer to take a leap over the complexities involved in a number of use cases, such as: As described by Tim Hall, it allows multiple transactionally consistent environments to exist within one database.ĭon’t confuse OWM with Oracle APEX workspaces, or with Analytic Workspace Manager for Oracle OLAP. Oracle Workspace Manager (OWM) is a feature of the Oracle database that was built back in the 8i days and installed in Oracle by default since 9i. Instead, I’m adding this preamble to say “this was a very interesting feature of Oracle I learned but didn’t quite get to use, but hopefully someone will find it useful”. This means I’m unable to add a triumphant postscript saying “this was a great success and it’s being used to this day”. However, for unrelated reasons the project was significantly delayed and later rebooted with an updated set of requirements, which no longer require Oracle Workspace Manager. ![]() This is an article I wrote quite some time ago and put “on ice” until I completed the client project it was related to.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |