This section describes how to install export files.
After you import an application and any related files into the target Oracle Application Express instance, the files are stored in the Export Repository. Next, you must install them.
You can install export files in the following ways:
After you import the export file, click the Install button and follow the on-screen instructions.
Import the export files into App Builder and then install the files from the Export Repository.
Install the export files from SQL*Plus.
You can simplify the steps needed to deploy an application by creating a custom packaged application.
When you import an application and any related files into a target Oracle Application Express instance, the files are stored in the Export Repository. You can use the Export Repository to manage archived application exports, imports, and other files.
To access the Export Repository:
The Export Repository appears.
After you import an application export into an Oracle Application Express instance, you must install it before it can become active or available in App Builder.
To install an application export from the Export Repository:
This is the schema against which all of the application's SQL and PL/SQL are parsed.
Run Application Only
Run and Build Application
Select Run Application Only to run the application in the target instance and make it inaccessible to developers.
If you select Run Application Only, the only way to change this setting after you import the application is to log in to Oracle Application Express Administration Services.
Auto Assign New Application ID
Reuse Application ID from Export File
Change Application ID
Use these options to avoid application ID conflicts. Use these options when you must 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 the development version.
If you are installing a custom packaged application, the installer prompts you to install the custom packaged installation scripts. Follow the on-screen instructions.
After you import files into an Oracle Application Express instance, you must install them before they can become active or available in App Builder.
To install files stored in the Export Repository:
You can delete a file from the Export Repository.
To delete a file from the Export Repository:
You can also install export files from SQL*Plus. The export file must originate from the same user database account as the one into which you are installing.
The following restrictions apply for export files:
If the export file is a database application, then the application ID is overwritten. Therefore, the target workspace must own the ID of the application being installed.
If the export file is a Websheet application, then the target workspace must have Websheet Database objects set-up.
If the export file is a Websheet application, then the export file must be installed using the Websheet schema in the target workspace.
If the export file is a Websheet application, then the application ID is overwritten.