1. App Builder User's Guide
  2. Deploying an Application
  3. Exporting and Importing from App Builder
  4. Exporting Workspaces, Applications, and App Components
  5. Exporting an Application Page

25.3.2.5 Exporting an Application Page

Move or copy a single application page by exporting it. You can export or page from the Export page or from Page Designer.

WARNING:

Exporting and importing a single page to a different system is an advanced deployment technique with the following restrictions:

  • Both systems have to have the same application ID and workspace ID.
  • Both systems have to have the same IDs for Shared Components.
  • If the page references new or updated Shared Components, those have to be exported and imported first.

If these restrictions are not fulfilled, the import will fail.

Parent topic: Exporting Workspaces, Applications, and App Components

25.3.2.5.1 Exporting an Application Page from the Export Page

Move or copy a single application page by exporting it from the Export Page.

To export a page from the Export page:

  1. Navigate to the Export page:
    1. On the Workspace home page, click the App Builder icon.
    2. On the App Builder home page, click Workspace Utilities.
    3. Click Export.

      The Export page appears.

      Tip:

      You can also access the Export page by selecting the application, Export/Import, and then Export.
  2. Click the Page tab.
  3. On the Export Page, configure the following:
    1. Application - Select the application that contains the page to be exported.
    2. Page - Select the page you wish to export. You can select only one page for export at a time.
    3. Export Format - Select a format. Options include:
    4. Include Installation files - Only displays if Export Format is set to ZIP. Options include:

      • On - Generates a ZIP archive including installation files specifically for the exported page (for example, install.sql, set_environment.sql and end_environment.sql).

      • Off - Generates a ZIP file without the installation files. As a best practice, Oracle recommends Off when saving the files to a version control system so that application installation files are not overwritten.

    5. As of - Specify a time in minutes to go to back to for your export. This option enables you to go back in time in your application, perhaps to get back a deleted object.

      This utility uses the DBMS_FLASHBACK package. Because the timestamps 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 start up parameter UNDO_RETENTION (the default is three hours). However, this only influences the size of the undo table space. While two databases may 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 table space, forcing older data to be archived.

    6. File Character Set - Indicates the character set in which the export file will be encoded. When importing this file you will need to specify the same character set.
  4. Click Export .
  5. Import the Page Export into the target instance.

See Also:

Importing an Application, Page or Component Export

Parent topic: Exporting an Application Page

25.3.2.5.2 Exporting an Application Page from Page Designer

Move or copy a single application page by exporting it from Page Designer.

To export a page from Page Designer:

  1. View the page to be exported in Page Designer:
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. Select a page.
      Page Designer appears.
  2. On the Page Developer toolbar, click the Utilities menu (Utilities menu) and then select Export.
  3. On the Export Page, configure the following:
    1. Page - Displays the currently selected page.
    2. Export Format - Select a page format. Options include:
    3. Include Installation files - Only displays if Export Format is set to ZIP. Options include:

      • On - Generates a ZIP archive including installation files specifically for the exported page (for example, install.sql, set_environment.sql and end_environment.sql).

      • Off - Generates a ZIP file without the installation files. As a best practice, Oracle recommends Off when saving the files to a version control system so that application installation files are not overwritten.

    4. As of - Specify a time in minutes to go to back to for your export. This option enables you to go back in time in your application, perhaps to get back a deleted object.

      This utility uses the DBMS_FLASHBACK package. Because the timestamps 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 start up parameter UNDO_RETENTION (the default is three hours). However, this only influences the size of the undo table space. While two databases may 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 table space, forcing older data to be archived.

    5. File Character Set - Indicates the character set in which the export file will be encoded. When importing this file you will need to specify the same character set.
  4. Click Export .
  5. Import the Page Export into the target instance.

See Also:

Importing an Application, Page or Component Export

Parent topic: Exporting an Application Page