Importing Export Files

Once you export an application and any related files, you need to import them into the target Oracle Application Express instance before you can install them. As a general rule, always import the application first and then the related files.

To import an application and related files:

On the Database Home Page, click the Application Builder icon.
Select an application.
On the Application Builder home page, click Export/Import.
When prompted to select a task, select Import and click Next.
On Import File:
1. In Import file, specify the file you are importing.
2. From File Type, select the type of file you are importing.
  
  Once you have imported a file, you have the option to install it. You can also install it later from the Export Repository.
3. Verify that File Character Set is correct.
4. Click Next.
To install an imported file, click Install. On the Application Install page:
1. From Parse As Schema, select a schema.
  
  This is the schema against which all of the application's SQL and PL/SQL will be parsed.
2. From Build Status Override, select one of the following:
  - Run Application Only - Users can only run an application.
  - Run and Build Application - Users can run an application and developers can both run and edit an application
  Selecting Run Application Only is an effective way to protect an application from modifications from other developers.
3. From Install As Application, select one of the following:
  - Auto Assign New Application ID
  - Reuse Application ID From Export File
  - Change Application ID
  Use these options to avoid application ID conflicts. These options come in handy when you need to have two versions of the same application in the same instance. For example, you might be migrating an application to a production instance and still need to maintain development version.
4. Click Install Application.