DROP PUBLIC DATABASE LINK rep.hr_group@rldba; //delete Database link
CREATE PUBLIC DATABASE LINK rep.hr_group@rldba CONNECT TO rldba IDENTIFIED BY admin USING 'rldba'; //Create Database linkselect * from [email protected]_group@rldba; //Test the Database link
CREATE PUBLIC DATABASE LINK rep.hr_group@rldba CONNECT TO rldba IDENTIFIED BY admin USING 'rldba'; //Create Database linkselect * from [email protected]_group@rldba; //Test the Database link
connect to user
identified by usrpwd
using 'demona';//demona为用net8 easy config创建的连接字符串
目的方数据库的init.ora文件中的global_names设为false