25.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 immediately 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:

To simplify the steps needed to deploy an application, Oracle recommends creating a custom application. See How to Create a Custom Application.

• Importing an Application or Page Export
  Import the Application or Page Export on the Import page.
• Importing a Component
  Import a Component 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 UI Defaults
  Import the UI 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
• Managing Export Files from the Export Repository
• Exporting and Importing from a Command Line in Oracle APEX Administration Guide

25.3.3.1 Importing an Application or Page Export

Import the Application or Page 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 or Page 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 to import the file.

   The Install Application Wizard appears.

   You can install the file now or install it at a later time by navigating to the Export Repository.

4. To install the file:
   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 - Select how to install this application. You must specify an application ID that is unique across all workspaces. Options include:

      • Auto Assign New Application ID - A new application ID will be created for you.

      • Reuse Application ID XX From Imported Application - The existing application ID will be used. When you install an application with the same ID as an existing application in the current workspace, the existing application is deleted and then replaced by the new application.

      • 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.
      The file is installed. What appears next, depends upon the type of export. For example, the export could include Credentials, Remote Servers, or supporting objects.
5. If Credentials or Remote Servers are detected, follow the on-screen instructions to set up the Credentials or Remote Servers for your workspace.
6. If supporting objects are detected, the wizard guides you through the installation process. Click Install Supporting Objects and follow the on-screen instructions.
7. On the confirmation page, 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

25.3.3.2 Importing a Component

Import a Component on the Import page.

Tip:

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

To import a Component:

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 to import the file.

   The Install Application Components Wizard appears.

   You can install the file now or install it at a later time by navigating to the Export Repository.

To install the file now:

4. For Install into Application, select the target application.
   You can install a component into the application you exported it from or into a different application.

   Tip:

   When you install a component into the application it was exported from, the new Component overwrites the existing component with the same component name.
5. Click Next.
6. Click Replace Application Components.

Note:

Importing templates to different applications or workspaces is not currently supported.

25.3.3.3 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, Page or Component Export.
   3. File Character Set - Verify that the File Character Set is correct.
   4. Click Next to import the file.

   The Install Application Wizard appears.

   You can install the export file now or install it at a later time by navigating to the Export Repository.

4. To install the export file:
   On Install Application 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 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 import.
   5. Click Install Application.

   A variation on the following message appears:

   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 terminated; waiting ones will be deleted.
5. 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.
6. Install Supporting Objects - To continue and install supporting objects, enable Install Supporting Objects and click Next.
7. If Credentials or Remote Servers are detected, follow the on-screen instructions to set up the Credentials or Remote Servers for your workspace.
8. If supporting objects are detected, the wizard guides you through the installation process. Click Install Supporting Objects and follow the on-screen instructions.
9. On the confirmation page, select the appropriate button:
   • Install Summary
   • Edit Application
   • Run Application

See Also:

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

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

25.3.3.5 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

25.3.3.6 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 Plug-in:
   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.

See Also:

Exporting Plug-ins

25.3.3.7 Importing UI Defaults

Import the UI Defaults Export on the Import page.

You can install a UI Defaults Table Dictionary export into any schema provisioned in the workspace. When you install a Table Dictionary export, the old defaults will be overwritten. UI 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 UI Defaults becomes permanent. If any errors are encountered, the actions are rolled back, resulting in no permanent changes.

To import a UI 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 UI 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 UI Defaults.

See Also:

• Managing UI Defaults in Oracle APEX SQL Workshop Guide

• Exporting UI Defaults

25.3.3.8 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