Exporting and Importing a Workspace

To move a workspace and all associated users to a new Oracle Application Express instance, an Instance administrator must export the workspace. When you export a workspace, Oracle Application Express generates a text file. This file contains information about your workspace, all the users in your workspace, and any groups in your workspace (if applicable). You can use this file to import your workspace into another Oracle Application Express instance.

Exporting a workspace and importing it into a new database instance enables developers to import application components. Therefore, to provide maximum capabilities Oracle recommends that when building new environments (for example, for production or testing) create these workspaces by importing the development workspaces.

Keep in mind, this method only imports 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.

Exporting a Workspace

To export a workspace:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Workspaces.
Under Export Import, click Export Workspace.
Select a workspace and then click Export Workspace.
To export the selected workspace, click Save File.
Follow the on-screen instructions.

Importing a Workspace

To import a workspace:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Workspaces.
Under Export Import, click Import Workspace.
Click Browse, select a workspace export file, and click Next.
To install the workspace, click Install.
Follow the on-screen instructions.