Exporting an Application

When you export an application, Oracle Application Express generates a text file containing PL/SQL API calls.

To export an application:

1. Navigate to the Export page:

   1. On the Workspace home page, click the Application Builder icon.

   2. On the Application Builder home page, click Export.

2. On the Export page, click the Application tab.

3. Under Choose Application, select the application to export.

4. Under Export Application, specify the following:

   1. File Format - Select how rows in the export file will be formatted:

      • Choose UNIX to have the resulting file contain rows delimited by line feeds.

      • Choose DOS to have the resulting file contain rows delimited by carriage returns and line feeds.

   2. Owner Override - Optionally select another owner. By default, the application is owned by the owner identified in the application attribute owner.

   3. Build Status Override - Select one of the following:

      • Run Application Only - Developers can only run an application

      • Run and Build Application - Developers can both run and edit 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 cannot set the argument p_trace to Yes. See "Using Build Options to Control Configuration". Also, the only way to change this setting after you import the application, is to log in to Oracle Application Express Administration Services. See "Changing Application Build Status Set During Deployment" in Oracle Application Express Administration Guide.

      
      

   4. Debugging - Select one of the following:

      • Yes exports the application with debugging enabled.

      • No exports the application with debugging disabled.

   5. As of - Enables you to go back in time and export a previous version of your application. For example, you can use this option to export a version of your application that contain an object that is currently deleted. Specify the number of minutes in the field provided.

      This utility uses the DBMS_FLASHBACK package. Because the timestamp to System Change Number (SCN) mapping is refreshed approximately every five minutes, you may have to wait that amount of time to locate the version for which you are looking. The time undo information is retained and influenced by the startup parameter UNDO_RETENTION (the default is three hours). However, this only influences the size of the undo tablespace. While two databases can have the same UNDO_RETENTION parameter, you are able to go back further in time on a database with fewer transactions because it is not filling the undo tablespace, forcing older data to be archived.

5. Under Export Preferences, select Yes or No to include or exclude the following:

   • Export Supporting Object Definitions. See "How to Create a Packaged Application".

   • Export Public Interactive Reports. See "Saving a Report".

   • Export Private Interactive Reports. See "Saving a Report".

   • Export Interactive Report Subscriptions. See "Subscribing to Emailed Reports".

   • Export Developer Comments. See "Adding Developer Comments".

   To learn more about a specific attribute, click the item label. When Help is available, the item label changes to red when you pass your cursor over it and the cursor changes to an arrow and question mark. See "About Field-Level Help".

6. Click Export Application.

In addition to exporting the actual application file, you may also need to export other related files such as cascading style sheets, images, and script files.