Previous Next JavaScript must be enabled to correctly display this content

## 3.11.9 Exporting and Importing a Workspace

Move a workspace and all associated users to a new Oracle APEX instance by exporting and importing.

- About Exporting and Importing a Workspace
  To move a workspace and all associated users to a new Oracle APEX instance, you export the workspace.
- Exporting a Workspace in Administration Services
  Create a Workspace Export by navigating to Manage Workspaces and selecting Export Workspace.
- Importing a Workspace in Administration Services
  Import a Workspace Export by navigating to Manage Workspaces and selecting Import Workspace.

See Also:

Deploying an Application in Oracle APEX App Builder User’s Guide

Parent topic: Managing Existing Workspaces

### 3.11.9.1 About Exporting and Importing a Workspace

To move a workspace and all associated users to a new Oracle APEX instance, you export the workspace.

When you export a workspace, Oracle APEX generates readable script file with a `.SQL` extension. This file contains information about your workspace, all the users in your workspace, and any groups in your workspace (if applicable). You can import this file into another Oracle APEX instance.

Exporting a workspace and importing it into a new database instance enables developers to import application components. When building new environments (for example, moving from development to testing or testing to production), Oracle recommends creating workspaces by importing them.

Keep in mind, this method only imports the workspace, users, and groups. This file does not contain:

- The schemas associated with this workspace or the objects in those schemas.

- Any applications, images, cascading style sheets, and static text files.

These items must be exported separately.

See Also:

Exporting an Application and Application Components in Oracle APEX App Builder User’s Guide

Parent topic: Exporting and Importing a Workspace

### 3.11.9.2 Exporting a Workspace in Administration Services

Create a Workspace Export by navigating to Manage Workspaces and selecting Export Workspace.

To create a Workspace Export:

1. Sign in to Oracle APEX Administration Services.
2. Click Manage Workspaces.
3. Under Export Import, click Export Workspace.

   Tip:

   To view a list of existing Workspace Imports, click View Imported Workspace Export Files under Tasks.

4. Select a workspace and then click Export Workspace.
5. On Export Workspace:
   1. Include Team Development - Set to Yes to include Team Development data. Otherwise, select No.
   2. Export Type:

      - Minimal - In most cases, accept the default value Minimal. Minimal includes the Workspace meta data, User Groups, and User definitions.

      - Full - Select Full to replicate to another instance all workspace artifacts including SQL Scripts, SQL Command History, saved SQL, user preferences, developer login history, email logs, and user interface defaults.

   3. File Character Set - Identifies the specified character set the for export file. When importing this file, you will need to specify the same character set.
6. To export the selected workspace, click Save File.

Parent topic: Exporting and Importing a Workspace

### 3.11.9.3 Importing a Workspace in Administration Services

Import a Workspace Export by navigating to Manage Workspaces and selecting Import Workspace.

To import a Workspace Export:

1. Sign in to Oracle APEX Administration Services.
2. Click Manage Workspaces.
3. Under Export Import, click Import Workspace.

   Tip:

   To view a list of existing Workspace Imports, click View Imported Workspace Export Files under Tasks.

4. Locate the import file and click Next.
5. To install the workspace, click Install.
6. Follow the on-screen instructions.

Parent topic: Exporting and Importing a Workspace