24.3.2.9 Exporting User Interface Defaults

Move or copy a User Interface Defaults by exporting them.

• About Exporting User Interface Defaults
  
• Exporting User Interface Defaults from the Export Page
  
• Exporting User Interface Defaults from the User Interface Defaults Page
  

24.3.2.9.1 About Exporting User Interface Defaults

Exporting User Interface Defaults is useful when you plan to develop on a target system. Developers use User Interface Defaults to populate initial values for region and item properties providing consistency across multiple pages in an application or multiple applications. User Interface 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 User Interface Defaults, all User Interface 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 User Interface Defaults to another database and Oracle APEX instance.

See Also:

• Importing User Interface Defaults
• Managing User Interface Defaults in Oracle APEX SQL Workshop Guide

24.3.2.9.2 Exporting User Interface Defaults from the Export Page

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

See Also:

Importing User Interface Defaults

24.3.2.9.3 Exporting User Interface Defaults from the User Interface Defaults Page

To export User Interface Defaults from the User Interface Defaults page:

1. On the Workspace home page, click the SQL Workshop icon.
2. Click Utilities.
3. Click User Interface Defaults.
4. Review the User Interface 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. Click Export.
7. Import the User Interface Defaults Export into the target instance.

See Also:

Importing User Interface Defaults