Creation and deletion of Dblink in Oracle

What Dblink connections are queried in the database

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

Delete a public emis_productoin connection

Drop public database link emis_production;

Create a public emis_production connection

Create Public database link Emis_production connect to emis_frame identified by Emis_frame using ' (DESCRIPTION = (address_l IST = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521))) (Connect_data = (service_name = testdb))) ';

Remove Emis_production Connection

drop database link emis_production;

Create a emis_production connection

Create DATABASE link emis_production connect to emis_frame identified by Emis_frame using ' (DESCRIPTION = (Address_list = (A ddress = (PROTOCOL = TCP) (HOST = 192.168.1.101) (PORT = 1521))) (Connect_data = (service_name = testdb))) ';

Test is available

SELECT * from [email protected]_production;

Creation and deletion of Dblink in Oracle