ORACLE DBLINKS

SELECT * FROM dba_db_links;
SELECT * FROM user_db_links;
DROP DATABASE LINK [link_name];
CREATE DATABASE LINK [link_name] CONNECT TO [user] IDENTIFIED BY [password] USING '[tns_alias]’;
SELECT count(*) FROM user_tables@[link_name];