Oracle DB Link Notes

drop public database link MYLINK;

 

CREATE public DATABASE LINK mylink

CONNECT TO RJMODI_SOURCE IDENTIFIED BY RJMODI_SOURCE

USING '//ODIGettingStarted:3621/orcl';

 

select *

from rjm_test@mylink;

 

select *

from RJMODI_TESTSOURCE.rjm_test;

 

 

select *

from all_objects

where object_name like '%RJM%'

;

 

 

select *

from ALL_DB_LINKS

;

drop public database link VM_TO_HOST;

 

CREATE public DATABASE LINK VM_TO_HOST

CONNECT TO RJMODI_TEMP IDENTIFIED BY RJMODI_TEMP

--USING '//cc-rjmetcal:1521/PDBORCL'

using '(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=cc-rjmetcal)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PDBORCL)))'

;

 

select * from rjmodi_testsource.rjm_test@vm_to_host;