25.3.2.9 Exporting UI Defaults

Move or copy a UI Defaults by exporting them.

• About Exporting UI Defaults
  Learn about exporting UI Defaults.
• Exporting UI Defaults from the Export Page
  Export UI Defaults from the Export page.
• Exporting UI Defaults from the UI Defaults Page
  Export UI Defaults from the UI Defaults page.

25.3.2.9.1 About Exporting UI Defaults

Learn about exporting UI Defaults.

Exporting UI Defaults is useful when you plan to develop on a target system. Developers use UI Defaults to populate initial values for region and item properties providing consistency across multiple pages in an application or multiple applications. UI Defaults are divided into two categories:

• The Table Dictionary consists is specific to tables and columns within a selected schema. These defaults are used over those defined in the Attribute Dictionary.
• The Attribute Dictionary contains a set of attributes about a column that is used in creating forms and reports. The definitions are matched by column name and a particular definition can be shared among several columns by using synonyms.

When you export UI Defaults, all UI Defaults for the selected dictionary and schema are exported to a single script. When prompted, save this file to your hard drive. The file contains an API call to create table hints by making calls to the application PL/SQL API. You can use this file to import UI Defaults to another database and Oracle APEX instance.

See Also:

• Importing UI Defaults
• Managing UI Defaults in Oracle APEX SQL Workshop Guide

25.3.2.9.2 Exporting UI Defaults from the Export Page

Export UI Defaults from the Export page.

To export UI Defaults:

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 UI Defaults tab.
3. Under Table Dictionary:
   1. Schema - Select the name of the schema to be exported.
   2. File Character Set - Displays the character set in which the export file will be encoded.
4. Attribute Dictionary, Count of Columns - Displays the number of entries in the Attribute Dictionary
5. Click Export.
6. Import the UI Defaults Export into the target instance.

See Also:

Importing UI Defaults

25.3.2.9.3 Exporting UI Defaults from the UI Defaults Page

Export UI Defaults from the UI Defaults page.

To export UI Defaults from the UI Defaults page:

1. On the Workspace home page, click the SQL Workshop icon.
2. Click Utilities.
3. Click UI Defaults.
4. Review the UI Defaults page.
   • The Table Dictionary is specific to tables and columns within a selected schema. These defaults are used over any defined within the Attribute Dictionary.
   • The Attribute Dictionary contains a set of attributes about a column and are used in creating forms and reports.
5. To export the Table Dictionary:
   1. Click Table Dictionary.
   2. Under Tasks, click Export.
   3. File Format - Select a file format.

      • DOS - Select DOS to have the lines in the resulting file terminated by carriage returns and line feeds..

      • UNIX - Select UNIX to have the lines in the resulting file contain terminated by line feeds..

   4. Click Export.
6. Import the UI Defaults Export into the target instance.

See Also:

Importing UI Defaults