25.3.2.11 Exporting a Workspace

Move or copy a workspace by exporting it.

Exporting a workspace creates a readable script file with a .sql extension which includes user groups, users, Team Development data, and workspace artifacts including SQL Scripts, SQL Command History, saved SQL, user preferences, developer login history, email logs, and UI Defaults. Workspace exports do not include applications.

Oracle does not recommend exporting an entire workspace unless you want to migrate workspace users or replicate Shared Component subscriptions in the target instance.

To export a workspace:

1. Navigate to the Export page:
   1. On the Workspace home page, select App Builder.
   2. On the App Builder home page, select Workspace Utilities.
   3. Click Export.

      The Export page appears.

      Tip:

      You can also access the Export page by selecting the application, Export/Import, and then Export.
2. Click the Workspace tab.
3. Include Team Development - Set to On to include Team Development data. Only select Off if the target instance for this workspace is a runtime only instance.
4. Include Extension Links - Enable this option to include Extension Links data in your workspace export file.
5. Export Type - In most cases, do not change the default value Minimal. Select Full if you want to replicate this workspace and all workspace artifacts including SQL Scripts, SQL Command History, saved SQL, user preferences, developer login history, email logs, and UI Defaults.
6. File Character Set - Identifies the character set in which the export file will be encoded.
7. Click Export.
8. Import the Workspace Export in Administration Services.

See Also:

Importing a Workspace in Administration Services in Oracle APEX Administration Guide