Use Oracle Workspace Manager in Autonomous Database

Use Oracle Workspace Manager to version-enable one or more user tables in the database. When a table is version-enabled, all rows in the table can support multiple versions of the data.

Note

You can use Workspace Manager only with Autonomous Database versions 19.23 or later.

Oracle Workspace Manager is enabled by default on Autonomous Database on Dedicated Exadata Infrastructure.

Applications that can benefit from Workspace Manager typically do one or more of the following operations:

  • Manage a collection of updates and insertions as a unit before incorporating them into production data
  • Support a collaborative development effort
  • Use a common data set to create multiple scenarios for what-if analyses or multiple editions of data for publication
  • Keep a history of changes to data

Introduction to Workspace Manager provides relevant usage and reference information.