-
Select Actions > New Group .
OR
In the link list, select an existing link group.
-
Select Actions > New Link .
-
On the Link Definitions dialog, under Import method, select Single table or Module (multiple tables) and select the appropriate target table or module from the list.
You can import data only into a target table that has a table definition (for example, a table that has a correct definition of a primary key, foreign keys, and reference tables). If you import data into a target module, all the tables in the target module must have a table definition.
-
Under Source, from the Database type list, select Oracle.
-
Under Server name, type the server name where the source Oracle database resides.
-
Under User name and Password, provide logon information for connection to the source Oracle database.
-
Select Connect to establish a connection to the selected Oracle database.
-
From the Table list, select a table from which you want to import data.
If you are creating a new link based on an existing link, select Save as new link.
-
Select Apply and then Close.
-
Select to display the link you defined in the Link Explorer.