CREATE [PUBLIC] DATABASE LINK
IDENTIFIED BY
This link name is called "test" and uses an ID of jim (on the target database) identified by is the password (jim) using the test which is a connect string
CREATE DATABASE LINK test
CONNECT TO jim IDENTIFIED BY jim
USING 'test';