About Exporting and Importing User Interface Defaults

You export user interface defaults in the same way you export any related application file. Exporting user interface defaults from one development instance to another involves the following steps:

  1. Export the user interface defaults using the Export User Interface Defaults utility. See "Exporting User Interface Defaults".

  2. Import the exported file into the target Oracle Application Express instance. See "Importing User Interface Defaults".

  3. Install the exported file from Export Repository. See "Installing Export Files".

When you export user interface defaults, all user interface defaults for the selected schema are exported to a single script. 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 Application Express instance.