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

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 - Select Application, Page or Component Export.
   3. File Character Set - Verify that the 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. 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 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 - 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.
   The application installs.
6. Select the appropriate option:
   • Upgrade Application
   • Edit Application
   • Run Application

See Also:

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

24.3.3.2 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.3 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.4 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.5 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.6 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