Exporting an Application

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

To export an application:

On the Database Home Page, click the Application Builder icon.
Select an application.
On the Application Builder, click Export/Import.
When prompted to select a task, select Export and click Next.
From 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.
From 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. Note that if you select Run Application Only you cannot set the argument p_trace to Yes.
Use the As of field to export your application as it was previously defined. 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 will be 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.
Click Export Application.

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