24.7.1 About the Export Process

Move a workspace, application, or related files by creating an export and then importing and installing it into another Application Express instance.

The export process consists of following steps:

  1. Create the Export File.

    Exporting an application, page, and application components creates a readable script file with a .SQL extension.

  2. Import and Install the Export File.

    Import the Export File into the target Application Express instance and then install it. You can install an Export File directly after importing, install it from the Export Repository, or install it from SQL*Plus. As a best practice, Oracle recommends importing an application first and then the related files.