A Importing an Application into a Workspace

Upload a SQL script to your Oracle Application Express workspace to start at the beginning of any chapter in this tutorial.

You can use the Import functionality of App Builder to upload a script to your workspace to start at the beginning of a chapter. Each script creates an application to match the start of a chapter. Use these scripts to skip around the tutorial or to check your work prior to that chapter.

The files you upload are contained in a downloadable .zip file located here: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex19-demo-basic-5586158.zip

Each file incorporates all the changes you are instructed to make in the chapters preceding it and creates a new application named "Demo Projects" with a new application ID.

Tip:

If you already have a Demo Projects app in your workspace, you may want to rename you existing Demo Projects app by editing the Name attribute on the Edit Application Definition page. See "Editing Application Attributes" in the Oracle Application Express App Builder User’s Guide.

Prerequisites

To import an application, you must have the following:

• The .zip file containing the application export scripts: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex19-demo-basic-5586158.zip

• The sample dataset installed in "Populating Your Workspace"

• Sufficient space allocated to your workspace

  • to request more space, see "Requesting More Storage" in Oracle Application Express Administration Guide

Procedure

To import an application export file (*.sql):

1. On the Workspace home page, click App Builder to navigate to the App Builder Home Page.
2. Click Import.
   The Import dialog displays.
3. For Import:
   1. Import file - click the appropriate button to browse your system for a file (for example, in Chrome the Choose File button).
   2. Locate the extracted .zip archive.
   3. Select the desired script and click Open.

      Tip:

      To determine the appropriate script file name, see Starting from here at the beginning of a chapter.
   4. For File Type, select Database Application, Page or Component Export.
   5. Click Next.
4. On the File Import Confirmation page, click Next.
5. On the Install Database Application page, click Install Application.
   The new application builds.
6. Click Edit Application to navigate to the imported application’s overview in Application Builder.

You have imported the new application into your workspace.