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
• Keep a history of changes to data

Introduction to Workspace Manager provides relevant usage and reference information.

Workspace manager is enabled using the procedure DBMS_CLOUD_ADMIN.ENABLE_FEATURE.

Oracle Workspace Manager must be enabled to be used on Autonomous Database. You can migrate existing data that has enabled Oracle Workspace Manager.

1. Enable Oracle Workspace Manager.

   BEGIN 
      DBMS_CLOUD_ADMIN.ENABLE_FEATURE(
           feature_name => 'OWM');
   END;
   /

2. Restart the Autonomous Database instance.

   See Restart Autonomous Database for more information.

3. 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

4. (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.
5. Continue with the imported schemas or the new schemas.

Use the following steps to disable Oracle Workspace Manager on Autonomous Database.

1. Disable Oracle Workspace Manager.

   BEGIN 
      DBMS_CLOUD_ADMIN.DISABLE_FEATURE(
           feature_name => 'OWM');
   END;
   /

2. Query dba_cloud_config to verify that Oracle Workspace Manager is disabled.

   SELECT param_name, param_value FROM dba_cloud_config 
        WHERE UPPER(param_name) = 'OWM';
   
   0 rows selected.