oracle数据库dblink连接

数据库监听服务：lsnrctl start;  lsnrctl stop;  lsnrctl status;

数据库启动：dbstart; dbshut;

---

--查看dblink连接

select owner,object_name from dba_objects where object_type='DATABASE LINK';

select * from dba_db_links;

select sysdate from dual@username;

--删除dblink连接

drop database link dblink_name;

--关闭dblink连接

alter session close database link 'dblink_name';