Specify Destination Objects in a Table Map

The Table Map Editor displays pairs of corresponding source and destination objects that are mapped on each tab. Initially, the destination (or source 2) object names are populated with the same names as the source (or source 1) object names. You can edit the destination object names or select destination object names from each corresponding object list.

Edit Destination Names

You can edit destination names as follows:

  • Overtype a destination name directly.
  • Delete a destination name to ignore the corresponding source during a process.
  • Change the default qualifier for all unqualified names.
  • Right-click the Destination Table Column and select Populate.
    • Select Add to insert the source object names in any blank destinations.
    • Select Clear to remove all destination object names and insert the source object names.
    • Select Empty to remove all destination object names and leave each cell blank.
    • Select Copy This Entry to copy the source object name to the current destination object name.
  • Right-click the Destination Table Column and select List to open the Select a Destination dialog.

Select Destination Object Names from a List

The Select a Destination dialog provides a list of DB Aliases on the left and the corresponding list of objects on the right.

select a destination table dialog, showing db aliases and database table names, as described below

DB Alias

The DB Aliases are listed on the left and the selected DB Alias is shaded. To change the selection, double-click a DB Alias or overtype the DB Alias in the Pattern box. (If you change this selection in either place, it changes automatically in the other.)

Objects

The type of object (table, view, alias, synonym) and fully qualified table names appear in the right list box. The list is sorted in alphabetical order by Creator ID and table name.

Pattern

You can specify a Pattern to limit the list of database objects in the Select a Destination dialog. After you specify a pattern, click Refresh to redisplay the list based on your criteria. See Use a Pattern for more information.

Show Only

Select the specific type of object (all, alias, tables, views, synonyms) to display.