dblink

xiaoming访问wang
sys赋权
grant create public database link to xiaoming ;
select * from user_sys_privs where privilege like upper('%DATABASE LINK%') AND USERNAME='XIAOMING';

1 XIAOMING CREATE PUBLIC DATABASE LINK NO

 

create public database link TESTLINK connect to wang identified by "123456" USING '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.253.123)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = prod)
    )
  )';

select * from student@TESTLINK

drop  public database link  TESTLINK