Skip Headers
Oracle® Application Express Application Builder User's Guide
Release 4.1

Part Number E21674-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Installing 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:

Tip:

You can simplify the steps needed to deploy an application by creating a packaged application. See "How to Create a Packaged Application".

Topics:

Accessing the Export Repository

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:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. On the Application home page, click Utilities.

  4. Under General Utilities, click Export Repository.

    The Export Repository appears.

Installing an Application Export from the Export Repository

After you import an application export into an Oracle Application Express instance, you must install it before it can become active or available in Application Builder.

To install an application export from the Export Repository:

  1. Navigate to the Export Repository:

    1. On the Workspace home page, click the Application Builder icon.

    2. Select an application.

    3. On the Application home page, click Export/Import.

    4. On the Tasks list, click Manage Export Repository.

      The Export Repository appears.

  2. Select an application export and click Install in the Action column.

  3. Specify the following:

    1. Parsing Schema - Select a schema.

      This is the schema against which all of the application's SQL and PL/SQL will be parsed.

    2. Build Status - Select one of the following:

      • 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.

      Tip:

      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. See "Changing Application Build Status Set During Deployment" in Oracle Application Express Administration Guide.
    3. Install As Application - Select one of the following:

      • Reuse Application ID from Export File

      • Auto Assign New Application ID

      • 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.

    4. Click Install.

About Installing a Packaged Application

If you are installing a packaged application, the installer prompts you to install the packaged installation scripts. Follow the on-screen instructions.

Installing Other Files from the Export Repository

After you import files into an Oracle Application Express instance, you must install them before they can become active or available in Application Builder.

To install files stored in the Export Repository:

  1. Navigate to the Export Repository.

    1. On the Workspace home page, click the Application Builder icon.

    2. Select an application.

    3. On the Application home page, click Export/Import.

    4. On the Tasks list, click Manage Export Repository.

      The Export Repository appears.

  2. Select the file to be installed and click Install in the Action column.

  3. Follow the on-screen instructions and click the Install button.

Deleting Files from the Export Repository

You can delete a file from the Export Repository.

To delete a file from the Export Repository:

  1. Navigate to the Export Repository.

    1. On the Workspace home page, click the Application Builder icon.

    2. Select an application.

    3. On the Tasks list, click Manage Export Repository.

      The Export Repository appears.

  2. Select the file to be deleted and click Delete Checked.

Installing Export Files from SQL*Plus

You can also install export files from SQL*Plus.

The following restrictions apply for export files:

  • The export file must originate from the same user database account as the one into which you are installing.

  • If the export file is a database application, the application ID will be overwritten. Therefore, the target workspace must own the ID of the application being installed.

  • If the export file contains Supporting Object scripts, the scripts are not run when the application is installed. You can either log in to the Application Builder to install Supporting Objects, or copy the installation scripts to a standalone SQL*Plus script and run them from there.

  • If the export file is a Websheet application, the target workspace must have Websheet Database objects set-up.

  • If the export file is a Websheet application, the export file must be installed using the Websheet schema in the target workspace.

  • If the export file is a Websheet application, the application ID will be overwritten.

Topics:

Verifying If Source and Target Workspace IDs Are Identical

You can verify that the source and target workspaces are identical by running a query in SQL Command Processor.

To verify that the source and target workspaces are identical:

  1. Log in to the source workspace.

  2. Click the SQL Workshop icon on the Workspace home page.

  3. Click SQL Commands.

  4. Enter the following in the SQL editor pane and click Run:

    SELECT &WORKSPACE_ID. FROM DUAL
    
  5. Note the workspace ID.

  6. Log in to the target workspace.

  7. Repeat steps 2 through 5 to verify the workspace IDs match.

Using SQL*Plus to Install Export Files

To install Oracle Application Express export files from SQL*Plus:

  1. Log in to SQL*Plus.

  2. Run the export file.

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