Oracle数据库DBLINK创建/查询/删除

1、创建DBLINK

copy
create database link to_remoteDB
connect to scott identified by tiger
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))'; 

/**(SERVER = DEDICATED)加上用不了*/
/**using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))'*/

2、查询DBLINK

copy
select * from dba_db_links;
select owner,object_name from dba_objects where object_type='DATABASE LINK';
select * from ALL_DB_LINKS;

3、删除DBLINK

copy
DROP DATABASE LINK to_remoteDB;  
--或  
DROP PUBLIC DATABASE LINK to_remoteDB;