How to copy a global mapping list from one environment to another

Three steps are necessary in order to copy a global mapping list from one environment into another:

1. Export the key and values of the global mapping list as CSV file by running the following query in SQL Developer, select the data, right click and choose export (replace the name of the mapping list in the query first):
   
   SELECT  mp.key_value,
    mp.result_value
FROM tr_map_values mp,
    tr_migset_maps m
WHERE mp.tr_map_id = m.id
    AND m.migset_id IS NULL
    AND m.name = 'map_list';

2. Define the global mapping list in the target environment.

3. Import the key and values from the CSV file created in the first step using the "Import from file" functionality in the global mapping list screen.