24.9 Installing Export Files

After you create an Export File, you can install it directly after importing, install it from the Export Repository, or install it from SQL*Plus.

24.9.1 About Installing Export Files

When you import Export Files into a target APEX instance, the files are stored in the Export Repository. From the Export Repository, you can import, install, or delete Export Files.

After you create an Export File, you can install it in the following ways:

  • After Importing:

    After you import the Export Files, you can install them by clicking the Next button.

  • From the Export Repository:

    Import the Export Files and then install the files from the Export Repository.

  • From SQL*Plus:

    Install the export files from SQL*Plus.

Tip:

You can simplify the steps needed to deploy an application by creating a custom application.

24.9.2 Installing an Application Export from the Export Repository

If you did not install your Application Export after importing, you can install it in the Export Repository.

To install an Application Export from the Export Repository:

  1. Navigate to the Export Repository:
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. On the Application home page, click Utilities.
    4. Click Export Repository.
  2. Find the application export and click Install in the Action column.
  3. In the Install wizard:
    1. Parsing Schema - Select a schema. After the installation finishes successfully, this will be used to set the owner of the application.
    2. Build Status - Set the build status of the application. Options include:
      • Run Application Only - Users can only run an application.

        Selecting Run Application Only is an effective way to protect an application from modifications from other developers.

      • Run and Build Application - Users can run an application and developers can both run and edit an application.

      Tip:

      If you select Run Application Only, you can only change this setting after you import the application by signing in to Administration Services.

    3. Install As Application - Options include:
      • Auto Assign New Application ID - A new application ID will be created for you.

      • Reuse Application ID From Export File - The existing application ID will be used.

      • Change Application ID - Specify a new application ID.

      You must specify an application ID that is unique across all Application Express workspaces.

    4. Click Install Application.
    The application installs.

24.9.3 Installing Other Files from the Export Repository

If you did not install your Export Files after importing, you can install them in the Export Repository.

To install other Export Files stored in the Export Repository:

  1. Navigate to the Export Repository:
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. On the Application home page, click Utilities.
    4. Click Export Repository.
  2. Select the file to be installed and click Install in the Action column.
  3. Follow the on-screen instructions. The steps differ slightly depending upon the export type.

24.9.4 Deleting Files from the Export Repository

Delete Export Files from the Export Repository.

To delete Export Files stored in the Export Repository:

  1. Navigate to the Export Repository:
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. On the Application home page, click Utilities.
    4. Click Export Repository.
  2. Select the file to be deleted and click Delete Checked.

24.9.5 Installing Export Files from SQL*Plus

Install Export Files from SQL*Plus.

Restrictions When Installing Export files from SQL*Plus

When installing 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 applies to database application exports. The application is overwritten. Therefore, the target workspace must own the ID of the application being installed.

To install Export Files from SQL*Plus:

  1. Start SQL*Plus and connect to the database where Oracle Application Express is installed with the default schema for the workspace you are installing into:
    • On Windows:

      SYSTEM_DRIVE:\ sqlplus /nolog
      SQL> CONNECT <Default_Schema>
      Enter password: Default_Schema_Password
    • On UNIX and Linux:

      $ sqlplus /nolog
      SQL> CONNECT <Default_Schema>
      Enter password: Default_Schema_Password
  2. Run the export file.
    SQL> @f144.sql

    For example, if your export file is names f144.sql by default, you would type @f144 at the command prompt.