select * from dba_objects where object_type='DATABASE LINK';

drop public database link EMIS_PRODUCTION;

create public database link EMIS_PRODUCTION connect to EMIS_FRAME identified by EMIS_FRAME using '(DESCRIPTION =

(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)))

(CONNECT_DATA = (SERVICE_NAME = testdb))

)';

drop database link EMIS_PRODUCTION;

create database link EMIS_PRODUCTION connect to EMIS_FRAME identified by EMIS_FRAME using '(DESCRIPTION =

(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521)))

(CONNECT_DATA = (SERVICE_NAME = testdb))

)';

select * from EMIS_FRAME.sys_menu@EMIS_PRODUCTION;