How to create private public DB link in oracle DB
set pages 999 long 999 lines 999
col OWNER for a20
col DB_LINK for a20
col USERNAME for a10
col HOST for a10
select * from dba_db_links;
grant create database link to hr;
--private dblink
CREATE DATABASE LINK scott_bprod_private CONNECT TO scott IDENTIFIED BY tiger USING 'bprod';
--public db link
CREATE public DATABASE LINK scott_bprod_public CONNECT TO scott IDENTIFIED BY tiger USING 'bprod';
select * from dual@scott_bprod;
select count(*) from tab@scott_bprod;