Oracle by Example brandingImporting an Application Export to Oracle Exadata Express Cloud Service

section 0Before You Begin

This tutorial shows you how to import an Oracle Application Express application export to Oracle Exadata Express Cloud Service This tutorial takes approximately 10 minutes to complete.

Background

Application export files are created by the Oracle Application Express export feature. When you create the export file, Oracle Application Express allows you to generate a report of database objects the application needs in order to run successfully. Oracle SQL Developer can be used to create connections to move these objects from one database schema to another. This tutorial focuses on importing the application to Exadata Express and assumes any dependent database objects have already been moved.

What Do You Need?

  • An Oracle Application export file to import.
  • Access to an Oracle Exadata Express Cloud Service.
  • Access to Oracle Application Express in your Exadata Express Cloud Service.
  • Know how to access Oracle Application Express in your Exadata Express Cloud Service.
  • All application dependent objects must reside in the same Exadata Express schema you import the application export to.

section 1Import the App Export

  1. In Exadata Express Cloud Service, access Application Express. The Application Express home page appears.
  2. Click App Builder, on the Application Express home page.
  3. Click Import, on the App Builder home page.
    Import Option on the App Builder page
    Description of the illustration import.jpg
  4. For Import File, click Browse... and navigate to the application export file you want to import, and select it.
  5. For File Type, select Database Application, Page or Component Export and click Next.
    Selections on the Import page
    Description of the illustration Import page021.jpg
  6. Click Next on the File Import Confirmation page to install now.
    File Import Confirmation page
    Description of the illustration File Import Confirmation022.jpg

section 2Install the Imported App

  1. Examine the Install Database Application page, then click Install Application.
    Install Application
    Description of the illustration Install Application023.jpg
  2. Click Run Application, on the Application Installed page.
  3. When you return to the Application Builder home page, you will see the application that you migrated from your on-premises Oracle Database to Exadata Express in the Oracle Cloud!

more informationWant to Learn More?