Use Oracle Workspace Manager on
Autonomous Database
Workspace
Manager provides an infrastructure that enables applications to create
workspaces and group different versions of table row values in different
workspaces.
About Using Oracle Workspace Manager on 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.
About Using Oracle Workspace Manager on 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.
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
Query dba_cloud_config to verify that Oracle Workspace Manager is enabled.
SELECT param_name, param_value FROM dba_cloud_config WHERE
UPPER(param_name) = 'OWM';
PARAM_NAME PARAM_VALUE
---------- -----------
owm enabled
(Optional) If you have existing data using Oracle Workspace Manager on another database that you want to migrate to Autonomous Database, Oracle Workspace Manager provides import and export procedures that enable you to migrate the data. See Export_Schemas and Import_Schemas for additional information.
Continue with the imported schemas or the new schemas.