Previous Next JavaScript must be enabled to correctly display this content

## 25.3.2.8 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.

Parent topic: Creating Export Files

### 25.3.2.8.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

Parent topic: Exporting UI Defaults

### 25.3.2.8.2 Exporting UI Defaults from the Export Page

Export UI Defaults from the Export page.

Exporting UI Defaults to create a readable script file with a `.sql` extension.

To export UI Defaults:

1. Navigate to the Export page:
   1. On the Workspace home page, select App Builder.
   2. On the App Builder home page, select 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 - Identifies 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

Parent topic: Exporting UI Defaults

### 25.3.2.8.3 Exporting UI Defaults from the UI Defaults Page

Export UI Defaults from the UI Defaults page.

Exporting UI Defaults to create a readable script file with a `.sql` extension.

To export UI Defaults from the UI Defaults page:

1. On the Workspace home page, select SQL Workshop.
2. Select Utilities.
3. Select 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. Select 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.

      - Database

   4. Click Export.
6. To export the Attribute Dictionary:
   1. Select Attribute 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.

      - Database

   4. Click Export.
7. Import the export file into the target instance.

See Also:

Importing UI Defaults

Parent topic: Exporting UI Defaults