Download Oracle Database Application Express User's Guide

Exporting an Application and Related Files
■
4.
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.
Tip: If you select Run Application Only, you cannot set the
argument p_trace to Yes. See "Using Build Options to Control
Configuration" on page 12-28. 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" on page 22-44.
5.
From Supporting Object Definitions, specify whether or not to include packaged
installation scripts and configuration options. See "How to Create a Packaged
Application" on page 12-5.
6.
From Export Comments, specify whether or not to export comments for this
application. See "Adding Developer Comments" on page 5-22.
7.
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 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.
8.
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.
See Also:
"Enabling SQL Tracing and Using TKPROF" on page 10-2
Exporting Workspace Users
You can make an application available to other users by creating workspace users.
When you export workspace users, Oracle Application Express creates an ASCII text
SQL script of users and any defined user groups.
To export workspace users:
1.
Navigate to the Export page:
a.
On the Workspace home page, click the Application Builder icon.
b.
Select an application.
c.
On the Application home page, click Export/Import.
d.
On the Export/Import page, click Export and then click Next.
Deploying an Application 12-13