In the following statement, user hr on the remote database defines a fixed-user database link named local to the hr schema on the local database:
CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING ‘local’;
In the following statement, user hr on the remote database defines a fixed-user database link named local to the hr schema on the local database:
CREATE DATABASE LINK local
CONNECT TO hr IDENTIFIED BY hr
USING ‘local’;