Exporting a Page in an Application

Previous

Next

---

You can export a specific page within an application by clicking the Export button on the Page Definition. When exporting a page, remember the following:

• Exported pages can only be imported sucessfully if they have the same application ID and workspace ID.

• Some pages may reference shared components. To export all pages within an application as well as application shared components, you need to export the entire application.

To export a page in an application:

1. Navigate to the appropriate Page Definition:

   1. Navigate to the Database Home Page.

   2. Click the Application Builder icon.

   3. Select an application.

   4. Select a page.

      The Page Definition appears.

2. On the Page Definition, click Export at the top of the page.

3. From Page, select the page to be exported.

4. 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.

5. Use the As of field to export a page 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 may 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.

6. Click Export Page.