24.3.3 Importing Export Files

After you create Export files, you then import them into the target Oracle APEX instance.

After you import the files, you have the option to install them. You can also install them at a later time by navigating to the Export Repository.

Note that you cannot import an application created in a specific release into an earlier version. As a general rule, always import the application first and then the related files.

Tip:

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

• Importing an Application, Page or Component Export
  Import the Application, Page or Component Export on the Import page.
• Reimporting an Application Containing Background Processes
  Learn about the workflow when reimporting an application with background processes.
• About Importing Applications and Application Groups
  Application groups are exported with an application, Application Exports include a group ID, name, and comments.
• Importing Themes
  Import a Theme Export on the Import page.
• Importing Plug-ins
  Import the Plug-in Export on the Import page.
• Importing User Interface Defaults
  Import the User Interface Defaults Export on the Import page.
• Importing Team Development Feedback
  Import a Team Development Feedback Export on the Import page.
• Importing a REST Source Catalog
  Import a REST Source Catalog Export on the Import page.

See Also:

• Understanding the Export and Import Process
• How to Create a Custom Application
• Exporting and Importing from a Command Line in Oracle APEX Administration Guide

24.3.3.1 Importing an Application, Page or Component Export

Import the Application, Page or Component Export on the Import page.

Tip:

You can also import an export file from the Export Repository. Navigate to the Export Repository and click the Import File and then go to step 3.

To import an Application, Page or Component Export:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Indicate the type of export file to be imported. Select Application, Page or Component Export.
   3. File Character Set - Verify that the File Character Set is correct.
   4. Click Next.

      The export file is imported. Next, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install the export file, click Next.

   The Install Application Wizard appears.

5. Install:
   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 and Build Application - Users can run an application and developers can both run and edit an application.

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

      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 - Select how to install this application. Available 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 APEX workspaces.

   4. Click Install Application.
   5. Click Install.
   The application installs. What displays next depends upon the type of export
6. Install Supporting Objects - This option only appears if the Export includes supporting objects.
   To continue and install supporting objects, enable Install Supporting Objects and click Next.
7. Click Install.
   The export is installed. What appears next, depends upon whether you install supporting objects.
8. Select the appropriate button:
   • Upgrade Application
   • Install Summary
   • Edit Application
   • Run Application

See Also:

Changing Application Build Status Set During Deployment in Oracle APEX Administration Guide

24.3.3.2 Reimporting an Application Containing Background Processes

Learn about the workflow when reimporting an application with background processes.

Reimporting (or redeploying) an application which has background processes has a slightly different workflow compared to an initial Application Export import.

Tip:

You can also import an export file from the Export Repository. Navigate to the Export Repository and click the Import File and then go to step 3

To reimport an Application Export with background processes:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Indicate the type of export file to be imported. Select Application.
   3. File Character Set - Verify that the File Character Set is correct.
   4. Click Next.

      The export file is imported. Next, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install the export file, click Next.

   The Install Application Wizard appears.

5. Install:
   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 and Build Application - Users can run an application and developers can both run and edit an application.

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

      Note:

      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 - Since you are importing an application export again, select Change Application ID.
   4. New Application - Enter the ID of the application from your first imort.
   5. Click Install Application.

   A variation on the following message apears:

   The application to be replaced has page processes with background executions enabled. No process execution is running right now (9:45:24 PM).

   • Use the Disable Background Execution button to prevent new executions to be kicked off (by setting the Maximum Scheduler Jobs attribute to zero) and to return to this page.
   • Use the Replace Application button to install the imported application now. Running background executions will be aborted; waiting ones will be deleted.
6. Select the appropriate button:
   • Disable Background Execution - Prevents new executions from starting.
   • Replace Application - Install the imported application now. No background executions will run and any waiting executions will be deleted.
7. Install Supporting Objects - To continue and install supporting objects, enable Install Supporting Objects and click Next.
8. Click Install.
9. Select the appropriate button:
   • Install Summary
   • Edit Application
   • Run Application

See Also:

Changing Application Build Status Set During Deployment in Oracle APEX Administration Guide

24.3.3.3 About Importing Applications and Application Groups

Application groups are exported with an application, Application Exports include a group ID, name, and comments.

When importing an application, the application import follows these rules:

• On import, an application uses an existing group if the ID matches.
• If no application group exists with the same ID on the target system, then application import looks for another group ID with the same name. If a name match is found, the application is imported with the ID corresponding to this application group name.
• If no ID or name matches existing application groups on the target system then a new application group is created. The new application group uses the application group ID if that ID is not used in that Oracle APEX instance. If the group ID is being used, then a new ID is generated.

24.3.3.4 Importing Themes

Import a Theme Export on the Import page.

To import a Theme Export:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Select Theme Export.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install the file, click Next.

   The Install Application wizard appears.

5. Click Install Theme.

See Also:

• Using Themes
• Exporting Themes

24.3.3.5 Importing Plug-ins

Import the Plug-in Export on the Import page.

To import a Plug-in Export:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Select Plug-in.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install an imported file, click Next.
5. On Install:
   1. Install Into Application - Select the target application. You can install the plug-in into the same application or into a different application.

      Tip:

      When you install a plug-in into the current application, the new plug-in will overwrite an existing plug-in having the same plug-in name. If the installation succeeds, the installation of the plug-in becomes permanent. If any errors are encountered, the actions are rolled back, resulting in no permanent changes.
   2. Click Install Plug-in.

Note:

Importing a Plug-in from the Plug-in Page

24.3.3.6 Importing User Interface Defaults

Import the User Interface Defaults Export on the Import page.

You can install a User Interface Defaults Table Dictionary export into any schema provisioned in the workspace. When you install a Table Dictionary export, the old defaults will be overwritten. User Interface Defaults Attribute Dictionary imports replace any matching attribute definitions that are found but will not remove any existing attribute definitions that are not contained in the export. If the installation succeeds, the installation of the user interface defaults becomes permanent. If any errors are encountered, the actions are rolled back, resulting in no permanent changes.

To import a User Interface Defaults Export:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Select User Interface Defaults.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install an imported file, click Next.
5. Click Install User Interface Defaults.

See Also:

• Managing User Interface Defaults in Oracle APEX SQL Workshop Guide

• Exporting User Interface Defaults

24.3.3.7 Importing Team Development Feedback

Import a Team Development Feedback Export on the Import page.

To import a Team Development Feedback Export:

1. Sign in to the APEX instance.
2. Navigate to the Import page:
   1. On the Workspace home page, click the App Builder icon.
   2. On the App Builder home page, click Import.
3. On Import:
   1. Drag and drop, or navigate to the file.
   2. File Type - Select Team Development Feedback.
   3. File Character Set - Verify that File Character Set is correct.
   4. Click Next.

      Once you import a file, you have the option to install it. You can also install this file at a later time by navigating to the Export Repository.

4. To install an imported file, click Next.
5. Click Import Feedback.

See Also:

• Exporting Team Development Feedback

• Managing Feedback