25.3.2.3 Exporting a Workspace

Move or copy a workspace by exporting it.

Exporting a workspace creates a SQL script file 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 user interface 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, click the App Builder icon.
   2. On the App Builder home page, click 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. Under Export Workspace:
   1. 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.
   2. Include Extension Links - Enable this option to include Extension Links data in your workspace export file.
   3. Export Type - In most cases, do not change the default value Minimal. Only 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 user interface defaults.
   4. File Format - Indicates the character set in which the export file will be encoded.
4. Click Export.
5. Import the Workspace Export in Administration Services.

See Also:

Importing a Workspace in Administration Services in Oracle APEX Administration Guide