Create a database link

Use the SQL below to create a database link to another Oracle database. If the link is to be used for import and/or export of data, the <USER> has to be assigned the role DATABASE_EXP_FULL_DATABASE and/or DATABASE_IMP_FULL_DATABASE.

create public database link "TEST.X"
connect to <USER>
identified by "password"
using 'TEST'

The X in the "TEST.X" name of the link is to avoid problem when using CwDataManager.exe